DBA Data[Home] [Help]

APPS.PER_ADD_BUS dependencies on PAY_PAYROLL_ACTIONS

Line 940: from pay_payroll_actions

936: --
937: -- Added below cursor for bug#8278906
938: cursor c_payroll_actions(p_payroll_action_id in number) is
939: select effective_date
940: from pay_payroll_actions
941: where payroll_action_id = p_payroll_action_id
942: and ACTION_TYPE NOT in ('BEE','X');
943: --
944: cursor csr_dup_add_type_exists is

Line 1306: -- from pay_payroll_actions

1302: for actionCursor in csr_pay_roll_actions(assCursor.assignment_id) loop
1303: --- Fix for Bug # 8278906 .Used cursor c_payroll_actions instead of below SELECT query ---
1304: -- /*select effective_date
1305: -- into l_action_eff_date
1306: -- from pay_payroll_actions
1307: -- where payroll_action_id = actionCursor.payroll_action_id;*/
1308: for payrollCursor in c_payroll_actions(actionCursor.payroll_action_id) loop
1309: l_action_eff_date := payrollCursor.effective_date;
1310: --- Fix for Bug # 8278906 Ends ---