APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 2126: FROM per_periods_of_service pos

2122: CURSOR csr_hire_date(p_person_id NUMBER
2123: ,p_pension_number VARCHAR2)
2124: IS
2125: SELECT MAX(pos.date_start)
2126: FROM per_periods_of_service pos
2127: WHERE pos.person_id = p_person_id
2128: AND pos.date_start <= (SELECT MIN(effective_start_date)
2129: FROM per_people_f ppf
2130: WHERE ppf.person_id = p_person_id

Line 2145: per_periods_of_service pps,

2141: pps.actual_termination_date term_date, -- Termination Date
2142: pps.pds_information3 efile -- Termination Reason(EFile)
2143: FROM per_people_f ppf,
2144: per_assignments_f paf,
2145: per_periods_of_service pps,
2146: hr_soft_coding_keyflex scl
2147: WHERE paf.person_id = ppf.person_id
2148: AND paf.period_of_service_id = pps.period_of_service_id
2149: AND paf.assignment_id = p_assignment_id

Line 2674: , per_periods_of_service SERVICE

2670: SELECT SERVICE.date_start
2671: FROM
2672: /* Person current period of service date details */
2673: per_all_assignments_f ASSIGN
2674: , per_periods_of_service SERVICE
2675: WHERE p_payroll_date BETWEEN ASSIGN.effective_start_date
2676: AND ASSIGN.effective_end_date
2677: AND ASSIGN.assignment_id = p_assignment_id
2678: AND SERVICE.period_of_Service_id = ASSIGN.period_of_service_id;

Line 2774: FROM per_periods_of_service

2770: CURSOR c_term_check(p_person_id NUMBER
2771: ,p_effective_date DATE)
2772: IS
2773: SELECT '1'
2774: FROM per_periods_of_service
2775: WHERE actual_termination_date <= p_effective_date
2776: AND person_id = p_person_id
2777: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2778: FROM per_periods_of_service

Line 2778: FROM per_periods_of_service

2774: FROM per_periods_of_service
2775: WHERE actual_termination_date <= p_effective_date
2776: AND person_id = p_person_id
2777: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2778: FROM per_periods_of_service
2779: WHERE person_id = p_person_id
2780: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2781: );
2782:

Line 4398: per_periods_of_service pps

4394: FROM pay_payroll_actions ppa,
4395: pay_assignment_actions paa,
4396: per_time_periods ptp,
4397: per_all_assignments_f paf,
4398: per_periods_of_service pps
4399: WHERE paa.assignment_action_id = p_assignment_action_id
4400: AND ppa.payroll_action_id = paa.payroll_action_id
4401: AND ptp.payroll_id = ppa.payroll_id
4402: AND paf.assignment_id = paa.assignment_id