DBA Data[Home] [Help]

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 146: FROM pay_user_column_instances_f pui

142:
143: CURSOR csr_utv_check(c_business_group_id NUMBER
144: ,c_reporting_date DATE) IS
145: SELECT 1
146: FROM pay_user_column_instances_f pui
147: ,pay_user_columns puc
148: ,pay_user_tables put
149: WHERE pui.user_column_id = puc.user_column_id
150: AND puc.user_column_name = 'Holiday Type'

Line 260: FROM pay_user_column_instances_f pui

256: CURSOR csr_get_utv(c_business_group_id NUMBER
257: ,c_reporting_date DATE
258: ,c_holiday_type VARCHAR2) IS
259: SELECT pur.row_low_range_or_name accrual_plan
260: FROM pay_user_column_instances_f pui
261: ,pay_user_columns puc
262: ,pay_user_tables put
263: ,pay_user_rows_f pur
264: WHERE pui.user_column_id = puc.user_column_id