APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 126: FROM pay_user_columns puc

122: CURSOR csr_get_user_stat_balances(p_effecitve_date IN DATE) IS
123:
124: SELECT TRIM(user_column_name) bal_dimension
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

Line 147: FROM pay_user_columns puc

143: CURSOR csr_get_statutory_balances(p_effecitve_date IN DATE) IS
144:
145: SELECT TRIM(user_column_name) bal_dimension
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'

Line 1658: l_min_wage_type pay_user_columns.user_column_name%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;
1661: l_org_struct_ver_id NUMBER;
1662: l_legal_min_payment VARCHAR2(240);