DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PER_ASSIGNMENTS_F

Line 1514: from per_assignments_f

1510: -- is a valid assignment_id at this stage.
1511: --
1512: /* select distinct person_id
1513: into l_person_id
1514: from per_assignments_f
1515: where assignment_id = l_assignment_id;
1516: debug_msg( 'Person id ' || l_person_id || ' for assignment id ' ||
1517: l_assignment_id );
1518: balance := goto_per_latest_balances( p_assignment_action_id,

Line 1681: per_assignments_f paf

1677: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1678: paa.assignment_action_id),16))
1679: from pay_assignment_actions paa,
1680: pay_payroll_actions ppa,
1681: per_assignments_f paf
1682: where paa.assignment_id = p_assignment_id
1683: and paf.assignment_id = p_assignment_id
1684: and paf.assignment_id = paa.assignment_id
1685: and ppa.payroll_action_id = paa.payroll_action_id