APPS.JAI_ETCS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 148: , cp_rgm_code IN JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS

144: | cp_end_date IN DATE YES End date of Given financial year |
145: ---------------------------------------------------------------------------------------------------------------------------------*/
146: PROCEDURE get_start_end_date(
147: cp_attr_code IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR
148: , cp_rgm_code IN JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE --TDS / TCS
149: , cp_fin_year IN NUMBER
150: , cp_start_date OUT NOCOPY GL_PERIODS.START_DATE%TYPE
151: , cp_end_date OUT NOCOPY GL_PERIODS.END_DATE%TYPE
152: )

Line 158: FROM JAI_RGM_DEFINITIONS jrd,

154:
155: cursor c_get_tcs_rgm_atrbt
156: is
157: SELECT jrr.ATTRIBUTE_VALUE
158: FROM JAI_RGM_DEFINITIONS jrd,
159: JAI_RGM_REGISTRATIONS jrr
160: WHERE jrd.REGIME_ID = jrr.REGIME_ID
161: AND jrr.ATTRIBUTE_CODE = cp_attr_code
162: AND jrd.REGIME_CODE = cp_rgm_code;

Line 213: from jai_rgm_definitions jrd,

209:
210: CURSOR c_org_exists (p_org_id NUMBER)
211: IS
212: select '1'
213: from jai_rgm_definitions jrd,
214: jai_rgm_parties jrp
215: where jrd.regime_code = 'TCS'
216: and jrd.regime_id = jrp.regime_id
217: and jrp.organization_id = p_org_id;

Line 223: jai_rgm_definitions jrd,

219: CURSOR c_party_setup (p_attr_code VARCHAR2, p_org_id NUMBER)
220: IS
221: select jrpr.attribute_value
222: from jai_rgm_parties jrp,
223: jai_rgm_definitions jrd,
224: jai_rgm_party_regns jrpr,
225: jai_rgm_registrations jrr
226: where jrd.regime_code = 'TCS'
227: and jrd.regime_id = jrp.regime_id

Line 236: from jai_rgm_definitions jrd,

232:
233: CURSOR c_regime_setup (p_attr_code VARCHAR2)
234: IS
235: select jrr.attribute_value
236: from jai_rgm_definitions jrd,
237: jai_rgm_registrations jrr
238: where jrd.regime_code = 'TCS'
239: and jrd.regime_id = jrr.regime_id
240: and jrr.attribute_code = p_attr_code;