APPS.HR_DELETE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 525: FROM pay_assignment_actions paa

521: FROM pay_pre_payments ppp
522: WHERE ppp.pre_payment_id
523: = cae.pre_payment_id
524: AND EXISTS ( SELECT ''
525: FROM pay_assignment_actions paa
526: WHERE paa.assignment_action_id
527: = ppp.assignment_action_id
528: AND EXISTS (SELECT ''
529: FROM per_assignments_f pa

Line 588: pay_assignment_actions paa,

584: cursor lbcur(p_bg_id number) is
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

Line 597: pay_assignment_actions paa,

593: union all
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

Line 606: pay_assignment_actions paa,

602: union all
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;

Line 623: update pay_assignment_actions act

619: begin
620: for c1rec in c1 loop
621: if(c1rec.action_type = 'Z') then
622: -- Ensure the Purge action can be rolled back.
623: update pay_assignment_actions act
624: set act.secondary_status = 'U'
625: where act.payroll_action_id = c1rec.payroll_action_id;
626: end if;
627: --