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