DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_PARTIES

Line 322: jai_rgm_parties jrp

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

Line 330: from jai_rgm_parties jrp,

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

Line 6387: from jai_rgm_parties jrp,

6383: END IF;
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'