APPS.HR_DELETE dependencies on PAY_PAYROLL_ACTIONS

Line 76: pay_payroll_actions.action_sequence).

72: Also, fix problem that still exists
73: with the order by that drives the
74: delete of assignment actions (should
75: not order by
76: pay_payroll_actions.action_sequence).
77: 80.3 22-FEB-94 JTHURING B402 Remove references to pay_holidays and
78: pay_holiday_parameters
79: 80.4 28-APR-94 DSAXBY G655 Need to delete hr_assignment_set rows
80: after payroll actions.

Line 589: pay_payroll_actions ppa

585: select palb.latest_balance_id,
586: 'ASG' bal_type
587: from pay_assignment_latest_balances palb,
588: pay_assignment_actions paa,
589: pay_payroll_actions ppa
590: where ppa.business_group_id = p_bg_id
591: and ppa.payroll_action_id = paa.payroll_action_id
592: and paa.assignment_action_id = palb.assignment_action_id
593: union all

Line 598: pay_payroll_actions ppa

594: select pplb.latest_balance_id,
595: 'PER' bal_type
596: from pay_person_latest_balances pplb,
597: pay_assignment_actions paa,
598: pay_payroll_actions ppa
599: where ppa.business_group_id = p_bg_id
600: and ppa.payroll_action_id = paa.payroll_action_id
601: and paa.assignment_action_id = pplb.assignment_action_id
602: union all

Line 607: pay_payroll_actions ppa

603: select plb.latest_balance_id,
604: 'AP' bal_type
605: from pay_latest_balances plb,
606: pay_assignment_actions paa,
607: pay_payroll_actions ppa
608: where ppa.business_group_id = p_bg_id
609: and ppa.payroll_action_id = paa.payroll_action_id
610: and paa.assignment_action_id = plb.assignment_action_id;
611: --

Line 615: from pay_payroll_actions pac

611: --
612: cursor c1 is
613: select pac.payroll_action_id,
614: pac.action_type
615: from pay_payroll_actions pac
616: where pac.business_group_id = p_business_group_id
617: order by pac.effective_date desc,
618: pac.payroll_action_id desc;
619: begin