DBA Data[Home] [Help]

APPS.JAI_ETCS_PKG dependencies on JAI_RGM_PARTIES

Line 214: jai_rgm_parties jrp

210: CURSOR c_org_exists (p_org_id NUMBER)
211: IS
212: select '1'
213: from jai_rgm_definitions jrd,
214: jai_rgm_parties jrp
215: where jrd.regime_code = 'TCS'
216: and jrd.regime_id = jrp.regime_id
217: and jrp.organization_id = p_org_id;
218:

Line 222: from jai_rgm_parties jrp,

218:
219: CURSOR c_party_setup (p_attr_code VARCHAR2, p_org_id NUMBER)
220: IS
221: select jrpr.attribute_value
222: from jai_rgm_parties jrp,
223: jai_rgm_definitions jrd,
224: jai_rgm_party_regns jrpr,
225: jai_rgm_registrations jrr
226: where jrd.regime_code = 'TCS'