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
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:
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'
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)