DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_PERSON_LATEST_BALANCES

Line 596: from pay_person_latest_balances pplb,

592: and paa.assignment_action_id = palb.assignment_action_id
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

Line 642: delete from pay_person_latest_balances

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;
644: else
645: delete from pay_latest_balances
646: where latest_balance_id = lbrec.latest_balance_id;