APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 129: ,pay_user_column_instances_f puci

125: ,TRIM(pur.row_low_range_or_name) bal_name
126: FROM pay_user_columns puc
127: ,pay_user_rows_f pur
128: ,pay_user_tables put
129: ,pay_user_column_instances_f puci
130: WHERE put.legislation_code IS NULL
131: AND put.business_group_id = p_bg_id
132: AND pur.user_table_id = put.user_table_id
133: AND puc.user_table_id = put.user_table_id

Line 150: ,pay_user_column_instances_f puci

146: ,TRIM(pur.row_low_range_or_name) bal_name
147: FROM pay_user_columns puc
148: ,pay_user_rows_f pur
149: ,pay_user_tables put
150: ,pay_user_column_instances_f puci
151: WHERE put.legislation_code = 'NL'
152: AND pur.user_table_id = put.user_table_id
153: AND puc.user_table_id = put.user_table_id
154: AND puci.user_row_id = pur.user_row_id

Line 1656: l_ret pay_user_column_instances_f.value%TYPE;

1652: l_period hr_lookups.meaning%TYPE;
1653: l_table hr_lookups.meaning%TYPE;
1654: l_age NUMBER;
1655: l_period_type pay_all_payrolls_f.period_type%TYPE;
1656: l_ret pay_user_column_instances_f.value%TYPE;
1657: l_struct_id NUMBER;
1658: l_min_wage_type pay_user_columns.user_column_name%TYPE;
1659: l_min_wage_factor NUMBER;
1660: l_bus_group_id NUMBER;