APPS.HR_JP_ID_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1864: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE

1860: FUNCTION period_of_service_rec(
1861: p_employee_number IN VARCHAR2,
1862: p_business_group_id IN NUMBER,
1863: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1864: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE
1865: --------------------------------------------------------------------------------
1866: IS
1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;
1868: CURSOR csr_period_of_service IS

Line 1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;

1863: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1864: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE
1865: --------------------------------------------------------------------------------
1866: IS
1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;
1868: CURSOR csr_period_of_service IS
1869: select pps.*
1870: from per_periods_of_service pps,
1871: per_all_people_f pp

Line 1870: from per_periods_of_service pps,

1866: IS
1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;
1868: CURSOR csr_period_of_service IS
1869: select pps.*
1870: from per_periods_of_service pps,
1871: per_all_people_f pp
1872: where pp.employee_number=p_employee_number
1873: and pp.business_group_id=p_business_group_id
1874: and p_effective_date

Line 1879: from per_periods_of_service pps2

1875: between pp.effective_start_date and pp.effective_end_date
1876: and pps.person_id=pp.person_id
1877: and ( pps.date_start=(
1878: select max(pps2.date_start)
1879: from per_periods_of_service pps2
1880: where pps2.person_id=pp.person_id
1881: and pps2.date_start <= pp.effective_end_date)
1882: );
1883: BEGIN