APPS.PAY_IN_TERMINATION_PKG dependencies on PER_PEOPLE_F

Line 10: g_hire_date per_people_f.start_date%TYPE;

6: g_legislation_code CONSTANT VARCHAR2(2) := 'IN';
7:
8: g_assignment_id per_assignments_f.assignment_id%TYPE;
9: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
10: g_hire_date per_people_f.start_date%TYPE;
11: g_notified_date per_periods_of_service.NOTIFIED_TERMINATION_DATE%TYPE;
12:
13: g_notice_et CONSTANT VARCHAR2(80):= 'Notice Period Information';
14: g_notice_cn CONSTANT VARCHAR2(80):= 'Notice Period Pay';

Line 616: ,per_people_f ppf

612: ,pos.leaving_reason
613: ,pos.notified_termination_date
614: FROM per_periods_of_service pos
615: ,per_assignments_f paf
616: ,per_people_f ppf
617: WHERE pos.period_of_service_id = p_period_of_service_id
618: AND pos.business_group_id = p_business_group_id
619: AND pos.period_of_service_id = paf.period_of_service_id
620: AND paf.person_id = ppf.person_id

Line 3552: ,per_people_f ppf

3548: ,pos.pds_information1
3549: ,pos.pds_information2
3550: FROM per_periods_of_service pos
3551: ,per_assignments_f paf
3552: ,per_people_f ppf
3553: ,hr_soft_coding_keyflex scl
3554: WHERE pos.period_of_service_id = p_period_of_service_id
3555: AND pos.business_group_id = p_business_group_id
3556: AND paf.assignment_id = p_assignment_id

Line 3570: l_NSSN per_people_f.per_information15%TYPE;

3566: AND p_actual_termination_date BETWEEN ppf.effective_start_date
3567: AND ppf.effective_end_date;
3568:
3569: l_procedure VARCHAR2(100);
3570: l_NSSN per_people_f.per_information15%TYPE;
3571: l_print_leav_reas VARCHAR2(50);
3572: l_efile_leav_reas VARCHAR2 (50);
3573:
3574: BEGIN