APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 321: from jai_rgm_definitions jrd,

317:
318: CURSOR c_org_exists (p_org_id NUMBER)
319: IS
320: select '1'
321: from jai_rgm_definitions jrd,
322: jai_rgm_parties jrp
323: where jrd.regime_code = 'TDS'
324: and jrd.regime_id = jrp.regime_id
325: and jrp.organization_id = p_org_id;

Line 331: jai_rgm_definitions jrd,

327: CURSOR c_party_setup (p_attr_code VARCHAR2, p_org_id NUMBER)
328: IS
329: select jrpr.attribute_value
330: from jai_rgm_parties jrp,
331: jai_rgm_definitions jrd,
332: jai_rgm_party_regns jrpr,
333: jai_rgm_registrations jrr
334: where jrd.regime_code = 'TDS'
335: and jrd.regime_id = jrp.regime_id

Line 344: from jai_rgm_definitions jrd,

340:
341: CURSOR c_regime_setup (p_attr_code VARCHAR2)
342: IS
343: select jrr.attribute_value
344: from jai_rgm_definitions jrd,
345: jai_rgm_registrations jrr
346: where jrd.regime_code = 'TDS'
347: and jrd.regime_id = jrr.regime_id
348: and jrr.attribute_code = p_attr_code;

Line 1920: ,jai_rgm_definitions jrd

1916: SELECT jl.meaning MEANING
1917: ,jl.lookup_code LOOKUP_CODE
1918: ,jrd.regime_id REGIME_ID
1919: FROM ja_lookups jl
1920: ,jai_rgm_definitions jrd
1921: WHERE jl.lookup_code = jrd.regime_code
1922: AND jl.lookup_type = G_JAI_INDIA_TAX_REGIMES
1923: AND jl.lookup_code = G_TDS
1924: ;

Line 3660: ,jai_rgm_definitions jrd

3656: BEGIN
3657: SELECT jatsm.section_code_revised INTO lv_output_string
3658: FROM jai_ap_tds_sec_map jatsm
3659: ,ja_lookups jl
3660: ,jai_rgm_definitions jrd
3661: WHERE jl.lookup_code = jrd.regime_code
3662: AND jl.lookup_type = G_JAI_INDIA_TAX_REGIMES
3663: AND jl.lookup_code = G_TDS
3664: AND jatsm.section_code = p_tds_section

Line 4994: ,JAI_RGM_DEFINITIONS gd

4990: ,p.end_date
4991: from gl_period_sets ps
4992: ,gl_periods p
4993: ,JAI_RGM_REGISTRATIONS rr
4994: ,JAI_RGM_DEFINITIONS gd
4995: Where ps.period_set_id = to_number(rr.attribute_value)
4996: and ps.period_set_name = p.period_set_name
4997: and gd.regime_code = 'TDS'
4998: and gd.regime_id = rr.regime_id

Line 6388: jai_rgm_definitions jrd,

6384:
6385: if (p_organization_id is null) then
6386: select count(*) into v_regime_override
6387: from jai_rgm_parties jrp,
6388: jai_rgm_definitions jrd,
6389: jai_rgm_party_regns jrpr,
6390: jai_rgm_registrations jrr
6391: where jrd.regime_code = 'TDS'
6392: and jrd.regime_id = jrp.regime_id