APPS.HR_PL_UTILITY dependencies on PER_PERIODS_OF_SERVICE

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

1003: select person_id
1004: from per_all_assignments_f
1005: where assignment_id=p_assignment_id;
1006:
1007: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
1008: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date
1009: from per_periods_of_service
1010: where person_id=r_person_id;
1011:

Line 1009: from per_periods_of_service

1005: where assignment_id=p_assignment_id;
1006:
1007: cursor csr_per_periods_of_service(r_person_id per_all_people_f.person_id%type) is
1008: select date_start start_date,nvl(ACTUAL_TERMINATION_DATE ,p_date) end_date
1009: from per_periods_of_service
1010: where person_id=r_person_id;
1011:
1012: cursor csr_pemp_without_start_date(r_person_id per_all_people_f.person_id%type) is
1013: select nvl(period_months,0) months,nvl(period_days,0) days,nvl(period_years,0) years

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

1059: fetch csr_person_id into l_person_id;
1060: close csr_person_id;
1061:
1062:
1063: /*start of calculation for per_periods_of_service*/
1064:
1065: for i in csr_per_periods_of_service(l_person_id) loop
1066: hr_pl_utility.per_pl_calc_periods
1067: (i.start_date ,

Line 1065: for i in csr_per_periods_of_service(l_person_id) loop

1061:
1062:
1063: /*start of calculation for per_periods_of_service*/
1064:
1065: for i in csr_per_periods_of_service(l_person_id) loop
1066: hr_pl_utility.per_pl_calc_periods
1067: (i.start_date ,
1068: i.end_date ,
1069: l_temp_period_days ,

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

1124: end if;
1125: end if;
1126: end loop;
1127: hr_utility.set_location(l_proc,20);
1128: /*End of calculation for records in per_periods_of_service*/
1129:
1130:
1131: /*Calculation start for per_previous_employers*/
1132: