APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2223: per_assignment_extra_info PX

2219:
2220: and PPTP.regular_payment_date >= /* Termination check for RTI NI Reporting assignment. */
2221: ( nvl(
2222: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,
2223: per_assignment_extra_info PX
2224: where paa1.assignment_id = BAL_ASSACT.assignment_id
2225: and paa1.person_id = paa2.person_id
2226: and PX.assignment_id = paa2.assignment_id
2227: and PX.AEI_INFORMATION1 = 'Y'

Line 3509: FROM per_assignment_extra_info

3505: CURSOR csr_ovn
3506: IS
3507: SELECT object_version_number,
3508: assignment_extra_info_id
3509: FROM per_assignment_extra_info
3510: WHERE assignment_id = p_assig_id
3511: AND information_type = p_type;
3512: BEGIN
3513: hr_utility.set_location('Entering: '||l_proc,1);