DBA Data[Home] [Help]

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PAY_USER_COLUMNS

Line 147: ,pay_user_columns puc

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'
151: AND puc.legislation_code = 'HU'

Line 261: ,pay_user_columns puc

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
265: AND puc.user_column_name = 'Holiday Type'