APPS.JAI_GST_TAX_DEFAULTATION_PKG dependencies on JAI_RGM_PARTIES

Line 43: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd

39: SELECT master_organization_id FROM oe_system_parameters;
40:
41: CURSOR cur_state(pn_organization_id IN NUMBER) IS
42: SELECT jrp.state_code state_code
43: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
44: WHERE jrp.ORGANIZATION_ID = pn_organization_id
45: AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
46: AND jrd.regime_id = jrp.regime_id
47: AND jrd.regime_code = jai_constants.cgst_regime

Line 52: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd

48: AND jrp.location_id = pn_location_id;
49:
50: CURSOR cur_sgst_state(pn_organization_id IN NUMBER) IS
51: SELECT jrp.state_code state_code
52: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
53: WHERE jrp.ORGANIZATION_ID = pn_organization_id
54: AND jrp.ORGANIZATION_TYPE = 'IO' --inventory organization
55: AND jrd.regime_id = jrp.regime_id
56: AND jrd.regime_code = jai_constants.sgst_regime

Line 60: v_state JAI_RGM_PARTIES.state_code%TYPE;

56: AND jrd.regime_code = jai_constants.sgst_regime
57: AND jrp.location_id = pn_location_id;
58:
59: v_organization_id NUMBER;
60: v_state JAI_RGM_PARTIES.state_code%TYPE;
61: BEGIN
62: IF pn_organization_id IS NULL THEN
63: OPEN cur_get_master_org_id;
64: FETCH cur_get_master_org_id

Line 119: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd

115: FUNCTION get_org_state(pn_org_id IN NUMBER) RETURN VARCHAR2 IS
116:
117: CURSOR cur_state IS
118: SELECT jrp.state_code state_code
119: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
120: WHERE jrp.ORGANIZATION_ID = pn_org_id
121: AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
122: AND jrd.regime_id = jrp.regime_id
123: AND jrd.regime_code = jai_constants.cgst_regime

Line 128: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd

124: AND jrp.state_code IS NOT NULL;
125:
126: CURSOR cur_sgst_state IS
127: SELECT jrp.state_code state_code
128: FROM JAI_RGM_PARTIES jrp, JAI_RGM_DEFINITIONS jrd
129: WHERE jrp.ORGANIZATION_ID = pn_org_id
130: AND jrp.ORGANIZATION_TYPE = 'OU' --operating unit
131: AND jrd.regime_id = jrp.regime_id
132: AND jrd.regime_code = jai_constants.sgst_regime

Line 135: v_state JAI_RGM_PARTIES.state_code%TYPE;

131: AND jrd.regime_id = jrp.regime_id
132: AND jrd.regime_code = jai_constants.sgst_regime
133: AND jrp.state_code IS NOT NULL;
134:
135: v_state JAI_RGM_PARTIES.state_code%TYPE;
136: BEGIN
137:
138: OPEN cur_state;
139: FETCH cur_state