APPS.PAY_IN_REPORTS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2095: per_periods_of_service service

2091: /*cursor to get the hire date details */
2092: CURSOR c_hire_date is
2093: SELECT service.date_start
2094: FROM per_assignments_f assign,
2095: per_periods_of_service service
2096: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2097: AND assign.assignment_id = p_assignment_id
2098: AND service.period_of_service_id (+)= assign.period_of_service_id;
2099:

Line 2204: from per_periods_of_service

2200:
2201: CURSOR c_termination_check(p_person_id NUMBER)
2202: IS
2203: select '1'
2204: from per_periods_of_service
2205: where actual_termination_date between p_effective_start_date and p_effective_end_date
2206: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
2207: FROM per_periods_of_service
2208: WHERE person_id = p_person_id

Line 2207: FROM per_periods_of_service

2203: select '1'
2204: from per_periods_of_service
2205: where actual_termination_date between p_effective_start_date and p_effective_end_date
2206: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
2207: FROM per_periods_of_service
2208: WHERE person_id = p_person_id
2209: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2210: )
2211: and person_id = p_person_id;

Line 4242: from per_periods_of_service

4238: ,p_effective_start_date DATE
4239: ,p_effective_end_date DATE)
4240: IS
4241: select nvl(actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'))
4242: from per_periods_of_service
4243: where actual_termination_date between p_effective_start_date and p_effective_end_date
4244: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
4245: FROM per_periods_of_service
4246: WHERE person_id = p_person_id

Line 4245: FROM per_periods_of_service

4241: select nvl(actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'))
4242: from per_periods_of_service
4243: where actual_termination_date between p_effective_start_date and p_effective_end_date
4244: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
4245: FROM per_periods_of_service
4246: WHERE person_id = p_person_id
4247: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
4248: )
4249: and person_id = p_person_id;

Line 4672: FROM per_periods_of_service pps

4668: -
4669: GREATEST
4670: ( pps.date_start,TO_DATE('01-'||p_contr_start,'DD-MM-YYYY'))
4671: ) + 1 days
4672: FROM per_periods_of_service pps
4673: WHERE pps.period_of_service_id IN
4674: (SELECT asg.period_of_service_id
4675: FROM hr_organization_units hoi
4676: ,hr_soft_coding_keyflex scf