APPS.JAI_BOE_GENERAL_PKG dependencies on JAI_RGM_DEFINITIONS

Line 29: jai_rgm_definitions jrg,

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
33: AND jrg.regime_id = cn_regime_id --

Line 49: jai_rgm_definitions jrg

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
52: AND jrg.regime_id = jrr.regime_id
53: AND acc.attribute_code = pv_account_type

Line 73: jai_rgm_definitions jrg,

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:
77: AND jrg.regime_id = cn_regime_id

Line 98: FROM jai_rgm_definitions

94: --Get the regime id
95:
96: SELECT regime_id
97: INTO ln_regime_id
98: FROM jai_rgm_definitions
99: WHERE regime_code = jai_constants.customs_regime;
100:
101: OPEN get_account_setup(ln_regime_id);
102: FETCH get_account_setup

Line 158: FROM jai_rgm_definitions

154: v_debug := jai_constants.no;
155:
156: SELECT regime_id
157: INTO ln_regime_id
158: FROM jai_rgm_definitions
159: WHERE regime_code = 'CUSTOMS';
160:
161: OPEN get_others_attribute_value(ln_regime_id);
162: FETCH get_others_attribute_value