DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 2235: per_assignment_extra_info PX

2231:
2232: and PPTP.regular_payment_date >= /* Termination check for RTI NI Reporting assignment. */
2233: ( nvl(
2234: (select max(fnd_date.canonical_to_date(px.AEI_INFORMATION2)) from per_all_assignments_f paa1, per_all_assignments_f paa2,
2235: per_assignment_extra_info PX
2236: where paa1.assignment_id = BAL_ASSACT.assignment_id
2237: and paa1.person_id = paa2.person_id
2238: and PX.assignment_id = paa2.assignment_id
2239: and PX.AEI_INFORMATION1 = 'Y'

Line 3514: FROM per_assignment_extra_info

3510: CURSOR csr_ovn
3511: IS
3512: SELECT object_version_number,
3513: assignment_extra_info_id
3514: FROM per_assignment_extra_info
3515: WHERE assignment_id = p_assig_id
3516: AND information_type = p_type;
3517: BEGIN
3518: hr_utility.set_location('Entering: '||l_proc,1);