APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 1977: FROM per_periods_of_service pos

1973: CURSOR csr_hire_date(p_person_id NUMBER
1974: ,p_pension_number VARCHAR2)
1975: IS
1976: SELECT MAX(pos.date_start)
1977: FROM per_periods_of_service pos
1978: WHERE pos.person_id = p_person_id
1979: AND pos.date_start <= (SELECT MIN(effective_start_date)
1980: FROM per_people_f ppf
1981: WHERE ppf.person_id = p_person_id

Line 2462: , per_periods_of_service SERVICE

2458: SELECT SERVICE.date_start
2459: FROM
2460: /* Person current period of service date details */
2461: per_all_assignments_f ASSIGN
2462: , per_periods_of_service SERVICE
2463: WHERE p_payroll_date BETWEEN ASSIGN.effective_start_date
2464: AND ASSIGN.effective_end_date
2465: AND ASSIGN.assignment_id = p_assignment_id
2466: AND SERVICE.period_of_Service_id = ASSIGN.period_of_service_id;

Line 2562: FROM per_periods_of_service

2558: CURSOR c_term_check(p_person_id NUMBER
2559: ,p_effective_date DATE)
2560: IS
2561: SELECT '1'
2562: FROM per_periods_of_service
2563: WHERE actual_termination_date <= p_effective_date
2564: AND person_id = p_person_id
2565: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2566: FROM per_periods_of_service

Line 2566: FROM per_periods_of_service

2562: FROM per_periods_of_service
2563: WHERE actual_termination_date <= p_effective_date
2564: AND person_id = p_person_id
2565: AND date_start = (SELECT MAX(TO_DATE(date_start,'DD-MM-YY'))
2566: FROM per_periods_of_service
2567: WHERE person_id = p_person_id
2568: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2569: );
2570:

Line 4173: per_periods_of_service pps

4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa,
4171: per_time_periods ptp,
4172: per_all_assignments_f paf,
4173: per_periods_of_service pps
4174: WHERE paa.assignment_action_id = p_assignment_action_id
4175: AND ppa.payroll_action_id = paa.payroll_action_id
4176: AND ptp.payroll_id = ppa.payroll_id
4177: AND paf.assignment_id = paa.assignment_id