DBA Data[Home] [Help]

APPS.PQP_UPDATE_WORK_PATTERN_TABLE dependencies on PAY_USER_ROWS_F

Line 152: FROM pay_user_rows_f pur

148: IS
149: SELECT pur.USER_ROW_ID
150: ,pur.effective_start_date
151: ,pur.effective_end_date
152: FROM pay_user_rows_f pur
153: WHERE user_table_id = p_user_table_id
154: AND row_low_range_or_name = p_user_row_name
155: AND ( pur.business_group_id = p_business_group_id
156: OR pur.legislation_code = p_legislation_code )

Line 187: l_day01_row_id pay_user_rows_f.user_row_id%TYPE ;

183: l_proc_name VARCHAR2(200) := g_package_name||
184: 'update_working_days_in_week';
185:
186:
187: l_day01_row_id pay_user_rows_f.user_row_id%TYPE ;
188: l_day01_details csr_get_row_id%ROWTYPE ;
189:
190: l_day01_eff_start_date date ;
191: l_day01_eff_end_date date ;

Line 472: FROM pay_user_rows_f pur

468:
469:
470: CURSOR csr_get_row_ids IS
471: SELECT user_row_id
472: FROM pay_user_rows_f pur
473: WHERE user_table_id = p_user_table_id
474: AND row_low_range_or_name LIKE 'Day __' -- this is hard coded as it is the seeded data.
475: AND p_effective_date BETWEEN pur.effective_start_date
476: AND pur.effective_end_date ;