APPS.PAY_IN_REPORTS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2676: per_periods_of_service service

2672: /*cursor to get the hire date details */
2673: CURSOR c_hire_date is
2674: SELECT service.date_start
2675: FROM per_assignments_f assign,
2676: per_periods_of_service service
2677: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2678: AND assign.assignment_id = p_assignment_id
2679: AND service.period_of_service_id (+)= assign.period_of_service_id;
2680:

Line 2785: from per_periods_of_service

2781:
2782: CURSOR c_termination_check(p_person_id NUMBER)
2783: IS
2784: select '1'
2785: from per_periods_of_service
2786: where actual_termination_date between p_effective_start_date and p_effective_end_date
2787: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
2788: FROM per_periods_of_service
2789: WHERE person_id = p_person_id

Line 2788: FROM per_periods_of_service

2784: select '1'
2785: from per_periods_of_service
2786: where actual_termination_date between p_effective_start_date and p_effective_end_date
2787: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
2788: FROM per_periods_of_service
2789: WHERE person_id = p_person_id
2790: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2791: )
2792: and person_id = p_person_id;

Line 4961: from per_periods_of_service

4957: ,p_effective_start_date DATE
4958: ,p_effective_end_date DATE)
4959: IS
4960: select nvl(actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'))
4961: from per_periods_of_service
4962: where actual_termination_date between p_effective_start_date and p_effective_end_date
4963: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
4964: FROM per_periods_of_service
4965: WHERE person_id = p_person_id

Line 4964: FROM per_periods_of_service

4960: select nvl(actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'))
4961: from per_periods_of_service
4962: where actual_termination_date between p_effective_start_date and p_effective_end_date
4963: and date_start = (SELECT max(to_date(date_start,'DD-MM-YY'))
4964: FROM per_periods_of_service
4965: WHERE person_id = p_person_id
4966: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
4967: )
4968: and person_id = p_person_id;

Line 5391: FROM per_periods_of_service pps

5387: -
5388: GREATEST
5389: ( pps.date_start,TO_DATE('01-'||p_contr_start,'DD-MM-YYYY'))
5390: ) + 1 days
5391: FROM per_periods_of_service pps
5392: WHERE pps.period_of_service_id IN
5393: (SELECT asg.period_of_service_id
5394: FROM hr_organization_units hoi
5395: ,hr_soft_coding_keyflex scf