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 3549: ,per_people_f ppf

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

Line 3567: l_NSSN per_people_f.per_information15%TYPE;

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