ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0A23869E053B46B63588994Y SELECT TL_fbt_tax_amount , TL_surcharge_amount , TL_edu_cess_amount , TL_sh_cess_amount , TL_fbt_tax_amount + TL_surcharge_amount + TL_edu_cess_amount + TL_sh_cess_amount TL_TAX_TOTAL FROM ( SELECT ROUND(SUM(jfr.fbt_tax_amount) ,:G_PRECISION) TL_FBT_TAX_AMOUNT , ROUND(SUM(jfr.fbt_surcharge_amount),:G_PRECISION) TL_SURCHARGE_AMOUNT , ROUND(SUM(jfr.fbt_edu_cess_amount) ,:G_PRECISION) TL_EDU_CESS_AMOUNT , ROUND(SUM(jfr.fbt_sh_cess_amount) ,:G_PRECISION) TL_SH_CESS_AMOUNT FROM jai_fbt_repository jfr, ja_lookups jl WHERE jfr.legal_entity_id = :p_legal_entity_id AND jfr.fringe_benefit_type_code =NVL(:p_fringe_benefit_type_code, jfr.fringe_benefit_type_code) AND jl.lookup_type = 'JAI_INDIA_FB_TYPES' AND jl.lookup_code = jfr.fringe_benefit_type_code AND ( ( jfr.source in ('Others','Payables') AND jfr.invoice_date >= NVL(trunc(:p_period_start_date), jfr.period_start_date) AND jfr.invoice_date <= NVL(trunc(:p_period_end_date) , jfr.period_end_date) ) OR ( jfr.manual_flag = 'Y' AND jfr.period_start_date >= NVL(trunc(:p_period_start_date), jfr.period_start_date) AND jfr.period_end_date <= NVL(trunc(:p_period_end_date) , jfr.period_end_date) ) ) ) JA JAIFBTREV US JA India - Fringe Benefits Transaction Review Application: Asia/Pacific Localizations Source: India - Fringe Benefits Transaction Review Report Short Name: JAIFBTREV DB package: ZHS JA 印度 - 附加福利事务处理复查报表 Application: 亚太地区本地化 Source: 印度 - 附加福利事务处理复查报表 Short Name: JAIFBTREV DB package: BI Publisher :g_precision :p_fringe_benefit_type_code :p_legal_entity_id :p_period_end_date :p_period_start_date 1 10 :p_legal_entity_id LOV Oracle JAI_FBT_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_entity_profiles where legal_entity_id in (select organization_id from jai_rgm_parties,jai_fbt_setup_headers where organization_type='LE' and organization_id=legal_entity_id and regime_id in (select regime_id from jai_rgm_definitions where regime_code='FBT') ) order by value,description Y US Legal Entity ZHS 法人主体 2 20 :p_fbt_year LOV Oracle JAI_FBT_YEAR Y select fbt_year id, fbt_year value, null description from jai_fbt_setup_headers where legal_entity_id=:$flex$.jai_fbt_legal_entity order by value,description Y US FBT Year ZHS FBT 年度 3 30 :p_period_start_date LOV Oracle JAI_REVIEW_REPORT_DATE Y select to_date(substr(fbt_date.d,1,7)||fbt_year.y) id, to_date(substr(fbt_date.d,1,7)||fbt_year.y) value, null description from (select to_char(to_date('01-APR-2005')+(rownum-1)) d from all_objects where rownum<=365) fbt_date,(select to_number('2005')+(rownum-1) y from all_objects where rownum<=50) fbt_year where exists (select 'x' from jai_fbt_setup_headers fbt_period where fbt_period.legal_entity_id=:$flex$.jai_fbt_legal_entity and fbt_period.fbt_year=:$flex$.jai_fbt_year and to_date(substr(fbt_date.d,1,7)||fbt_year.y) between fbt_period.period_start_date and fbt_period.period_end_date) order by to_date(substr(fbt_date.d,1,7)||fbt_year.y) Y US Period Start Date ZHS 期间起始日期 4 40 :p_period_end_date LOV Oracle JAI_REVIEW_REPORT_DATE Y select to_date(substr(fbt_date.d,1,7)||fbt_year.y) id, to_date(substr(fbt_date.d,1,7)||fbt_year.y) value, null description from (select to_char(to_date('01-APR-2005')+(rownum-1)) d from all_objects where rownum<=365) fbt_date,(select to_number('2005')+(rownum-1) y from all_objects where rownum<=50) fbt_year where exists (select 'x' from jai_fbt_setup_headers fbt_period where fbt_period.legal_entity_id=:$flex$.jai_fbt_legal_entity and fbt_period.fbt_year=:$flex$.jai_fbt_year and to_date(substr(fbt_date.d,1,7)||fbt_year.y) between fbt_period.period_start_date and fbt_period.period_end_date) order by to_date(substr(fbt_date.d,1,7)||fbt_year.y) Y US Period End Date ZHS 期间终止日期 5 50 :p_fringe_benefit_type_code LOV Oracle JAI_BENEFIT_TYPE Y select lookup_code id, lookup_code value, meaning description from ja_lookups where lookup_type='JAI_INDIA_FB_TYPES' and lookup_code in (select distinct fringe_benefit_type_code from jai_fbt_setup_lines where legal_entity_id=nvl(:$flex$.jai_fbt_legal_entity, legal_entity_id) and fbt_year=nvl(:$flex$.jai_fbt_year,fbt_year) ) order by value,description US Benefit Type ZHS 福利类型