APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JA_LOOKUPS

Line 1389: from ja_lookups

1385: )
1386: )
1387: and ROUNDING_BASIS in(
1388: select lookup_code
1389: from ja_lookups
1390: where lookup_type='JAI_ROUNDING_BASIS'
1391: and meaning = 'Tax Basis'
1392: )
1393: and not exists(

Line 1474: from ja_lookups

1470: )
1471: )
1472: and ROUNDING_BASIS in(
1473: select lookup_code
1474: from ja_lookups
1475: where lookup_type='JAI_ROUNDING_BASIS'
1476: and meaning = 'Tax'
1477: )
1478: and not exists(

Line 2877: FROM JA_LOOKUPS

2873:
2874: CURSOR c_get_section_codes
2875: IS
2876: SELECT LOOKUP_CODE SECTION_CODE
2877: FROM JA_LOOKUPS
2878: WHERE LOOKUP_TYPE = 'JAI_TDS_SECTION';
2879:
2880: cursor c_for_each_tds_section_new(
2881: p_invoice_id number,

Line 3685: FOR r_sec in (select lookup_code from JA_LOOKUPS where lookup_type = 'JAI_TDS_SECTION')

3681: END LOOP;
3682:
3683:
3684: --Initialize the PL/SQL table ppay_amt, for TDS_SECTION, it store the SECTION_CODE LEVEL, others SECTION_TYPE level
3685: FOR r_sec in (select lookup_code from JA_LOOKUPS where lookup_type = 'JAI_TDS_SECTION')
3686: LOOP
3687: ppay_amt(r_sec.lookup_code) := 0;--Section code level.
3688: END LOOP;
3689: ppay_amt('WCT_SECTION') := 0;--Section type level.

Line 3693: FOR r_sec in (select lookup_code from JA_LOOKUPS where lookup_type = 'JAI_TDS_SECTION')

3689: ppay_amt('WCT_SECTION') := 0;--Section type level.
3690: ppay_amt('ESSI_SECTION') := 0;--Section type level.
3691:
3692: --Allocate the prepay amount to Section code level for TDS_SECTION and Section type level for WCT_SECTION and ESSI_SECTION
3693: FOR r_sec in (select lookup_code from JA_LOOKUPS where lookup_type = 'JAI_TDS_SECTION')
3694: LOOP
3695: get_prepay_invoice_amt_new(
3696: p_invoice_id,
3697: 'TDS_SECTION',

Line 5932: FROM ja_lookups jl

5928: SELECT jatsm.section_code_revised
5929: FROM jai_ap_tds_sec_map jatsm
5930: WHERE jatsm.regime_id in (
5931: SELECT jrd.regime_id
5932: FROM ja_lookups jl
5933: ,jai_rgm_definitions jrd
5934: WHERE jl.lookup_code = jrd.regime_code
5935: AND jl.lookup_type = 'JAI_INDIA_TAX_REGIMES'
5936: AND jl.lookup_code = 'TDS'

Line 7016: FROM ja_lookups jl

7012: SELECT jatsm.section_code_revised
7013: FROM jai_ap_tds_sec_map jatsm
7014: WHERE jatsm.regime_id in (
7015: SELECT jrd.regime_id
7016: FROM ja_lookups jl
7017: ,jai_rgm_definitions jrd
7018: WHERE jl.lookup_code = jrd.regime_code
7019: AND jl.lookup_type = 'JAI_INDIA_TAX_REGIMES'
7020: AND jl.lookup_code = 'TDS'