DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_USER_TABLES

Line 116: FROM pay_user_tables put

112: --
113: --
114: CURSOR csr_user_stat_exists IS
115: SELECT 1
116: FROM pay_user_tables put
117: WHERE put.legislation_code IS NULL
118: AND put.business_group_id = p_bg_id
119: AND put.user_table_name = 'NL_USER_STATUTORY_BALANCES';
120: --

Line 128: ,pay_user_tables put

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
131: AND put.business_group_id = p_bg_id
132: AND pur.user_table_id = put.user_table_id

Line 149: ,pay_user_tables put

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'
152: AND pur.user_table_id = put.user_table_id
153: AND puc.user_table_id = put.user_table_id