APPS.JAI_BOE_GENERAL_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 28: jai_rgm_registrations jrr,

24: FROM (SELECT jrp.organization_id organization_id,
25: acc.attribute_value attribute_value,
26: jrp.regime_org_id
27: FROM jai_rgm_parties jrp,
28: jai_rgm_registrations jrr,
29: jai_rgm_definitions jrg,
30: jai_rgm_registrations acc
31: WHERE 1 = 1
32: AND jrg.regime_id = jrp.regime_id

Line 30: jai_rgm_registrations acc

26: jrp.regime_org_id
27: FROM jai_rgm_parties jrp,
28: jai_rgm_registrations jrr,
29: jai_rgm_definitions jrg,
30: jai_rgm_registrations acc
31: WHERE 1 = 1
32: AND jrg.regime_id = jrp.regime_id
33: AND jrg.regime_id = cn_regime_id --
34: AND jrg.regime_id = jrr.regime_id

Line 46: jai_rgm_registrations jrr,

42: (SELECT jrp.organization_id organization_id,
43: jpr.attribute_value attribute_value,
44: jrp.regime_org_id
45: FROM jai_rgm_parties jrp,
46: jai_rgm_registrations jrr,
47: jai_rgm_registrations acc,
48: jai_rgm_party_regns jpr,
49: jai_rgm_definitions jrg
50: WHERE jrg.regime_id = jrp.regime_id

Line 47: jai_rgm_registrations acc,

43: jpr.attribute_value attribute_value,
44: jrp.regime_org_id
45: FROM jai_rgm_parties jrp,
46: jai_rgm_registrations jrr,
47: jai_rgm_registrations acc,
48: jai_rgm_party_regns jpr,
49: jai_rgm_definitions jrg
50: WHERE jrg.regime_id = jrp.regime_id
51: AND jrg.regime_id = cn_regime_id

Line 72: jai_rgm_registrations jrr,

68: SELECT
69: acc.attribute_value attribute_value
70:
71: FROM
72: jai_rgm_registrations jrr,
73: jai_rgm_definitions jrg,
74: jai_rgm_registrations acc
75: WHERE 1 = 1
76:

Line 74: jai_rgm_registrations acc

70:
71: FROM
72: jai_rgm_registrations jrr,
73: jai_rgm_definitions jrg,
74: jai_rgm_registrations acc
75: WHERE 1 = 1
76:
77: AND jrg.regime_id = cn_regime_id
78: AND jrg.regime_id = jrr.regime_id

Line 88: ln_regime_id jai_rgm_registrations.regime_id%TYPE;

84:
85: ------------------------------------------------------
86: --Added by zhiwei for Bug#12781845 end
87:
88: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
89: ln_ccid NUMBER;
90: v_debug CHAR(1);
91: BEGIN
92: v_debug := 'Y';

Line 144: FROM jai_rgm_registrations

140: RETURN NUMBER IS
141:
142: CURSOR get_others_attribute_value(cn_regime_id IN NUMBER) IS
143: SELECT to_number(attribute_value)
144: FROM jai_rgm_registrations
145: WHERE regime_id = cn_regime_id
146: AND registration_type = 'ACCOUNTS'
147: AND attribute_code = 'DEPB';
148:

Line 149: ln_regime_id jai_rgm_registrations.regime_id%TYPE;

145: WHERE regime_id = cn_regime_id
146: AND registration_type = 'ACCOUNTS'
147: AND attribute_code = 'DEPB';
148:
149: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
150: ln_depb_account_id NUMBER;
151: v_debug CHAR(1);
152:
153: BEGIN