APPS.PAY_IN_TERMINATION_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 11: g_notified_date per_periods_of_service.NOTIFIED_TERMINATION_DATE%TYPE;

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';
15: g_retrenchment_et CONSTANT VARCHAR2(80):= 'Retrenchment Compensation Information';

Line 614: FROM per_periods_of_service pos

610: ,paf.payroll_id
611: ,ppf.start_date
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

Line 3547: FROM per_periods_of_service pos

3543: CURSOR c_emp_mon_pf_pos_dtls IS
3544: SELECT ppf.per_information15
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