DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 333: jai_rgm_registrations jrr

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
336: and jrp.regime_org_id = jrpr.regime_org_id
337: and jrr.attribute_code = p_attr_code

Line 345: jai_rgm_registrations jrr

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;
349:

Line 4993: ,JAI_RGM_REGISTRATIONS rr

4989: SELECT p.start_date
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'

Line 6390: jai_rgm_registrations jrr

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
6393: and jrp.regime_org_id = jrpr.regime_org_id
6394: and jrp.organization_id in (select distinct organization_id from jai_ap_tds_org_tan_v where org_tan_num = p_tan_number)