APPS.HR_PL_UTILITY dependencies on PER_PERIODS_OF_SERVICE

Line 961: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is

957: select person_id
958: from per_all_assignments_f
959: where assignment_id=p_assignment_id;
960:
961: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
962: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date
963: from per_periods_of_service
964: where person_id=r_person_id;
965:

Line 963: from per_periods_of_service

959: where assignment_id=p_assignment_id;
960:
961: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
962: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date
963: from per_periods_of_service
964: where person_id=r_person_id;
965:
966: cursor csr_pemp_without_start_date(r_person_id per_all_people_f.person_id%type) is
967: select nvl(period_months,0) months,nvl(period_days,0) days,nvl(period_years,0) years

Line 1017: /*start of calculation for per_periods_of_service*/

1013: fetch csr_person_id into l_person_id;
1014: close csr_person_id;
1015:
1016:
1017: /*start of calculation for per_periods_of_service*/
1018:
1019: for i in csr_per_periods_of_service(l_person_id) loop
1020: hr_pl_utility.per_pl_calc_periods
1021: (i.start_date ,

Line 1019: for i in csr_per_periods_of_service(l_person_id) loop

1015:
1016:
1017: /*start of calculation for per_periods_of_service*/
1018:
1019: for i in csr_per_periods_of_service(l_person_id) loop
1020: hr_pl_utility.per_pl_calc_periods
1021: (i.start_date ,
1022: i.end_date ,
1023: l_temp_period_days ,

Line 1082: /*End of calculation for records in per_periods_of_service*/

1078: end if;
1079: end if;
1080: end loop;
1081: hr_utility.set_location(l_proc,20);
1082: /*End of calculation for records in per_periods_of_service*/
1083:
1084:
1085: /*Calculation start for per_previous_employers*/
1086: