APPS.HR_DELETE dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 587: from pay_assignment_latest_balances palb,

583: --
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

Line 639: delete from pay_assignment_latest_balances

635: where latest_balance_id = lbrec.latest_balance_id;
636: end if;
637: --
638: if lbrec.bal_type = 'ASG' then
639: delete from pay_assignment_latest_balances
640: where latest_balance_id = lbrec.latest_balance_id;
641: elsif lbrec.bal_type = 'PER' then
642: delete from pay_person_latest_balances
643: where latest_balance_id = lbrec.latest_balance_id;