APPS.JAI_ETCS_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 147: cp_attr_code IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE --TDS_CALENDAR / TCS_CALENDAR

143: | cp_start_date IN DATE YES start date of Given financial year |
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

Line 159: JAI_RGM_REGISTRATIONS jrr

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;
163:

Line 225: jai_rgm_registrations jrr

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
228: and jrp.regime_org_id = jrpr.regime_org_id
229: and jrr.attribute_code = p_attr_code

Line 237: jai_rgm_registrations jrr

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;
241: