APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on GL_PERIODS

Line 91: -- cursor to get period year from gl_periods

87: WHERE jrd.REGIME_ID = jrr.REGIME_ID
88: AND jrr.ATTRIBUTE_CODE = cp_attr_code
89: AND jrd.REGIME_CODE = cp_rgm_code;
90:
91: -- cursor to get period year from gl_periods
92: CURSOR c_get_period_year(cp_calendar_id NUMBER,
93: cp_accounting_date DATE)
94: IS
95: SELECT a.PERIOD_YEAR

Line 96: FROM GL_PERIODS a

92: CURSOR c_get_period_year(cp_calendar_id NUMBER,
93: cp_accounting_date DATE)
94: IS
95: SELECT a.PERIOD_YEAR
96: FROM GL_PERIODS a
97: , gl_period_sets b
98: WHERE a.PERIOD_SET_NAME = b.period_set_name
99: AND b.period_set_id = cp_calendar_id
100: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;

Line 103: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;

99: AND b.period_set_id = cp_calendar_id
100: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;
101:
102: lv_gl_calendar_id number;
103: lv_fin_year GL_PERIODS.PERIOD_YEAR%TYPE;
104:
105: BEGIN
106:
107: OPEN c_get_tcs_rgm_atrbt;