DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on PER_ASSIGNMENTS_F

Line 1502: from per_assignments_f

1498: -- is a valid assignment_id at this stage.
1499: --
1500: /* select distinct person_id
1501: into l_person_id
1502: from per_assignments_f
1503: where assignment_id = l_assignment_id;
1504: debug_msg( 'Person id ' || l_person_id || ' for assignment id ' ||
1505: l_assignment_id );
1506: balance := goto_per_latest_balances( p_assignment_action_id,

Line 1657: per_assignments_f paf

1653: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1654: paa.assignment_action_id),16))
1655: from pay_assignment_actions paa,
1656: pay_payroll_actions ppa,
1657: per_assignments_f paf
1658: where paa.assignment_id = p_assignment_id
1659: and paf.assignment_id = p_assignment_id
1660: and paf.assignment_id = paa.assignment_id
1661: and ppa.payroll_action_id = paa.payroll_action_id