APPS.HR_PL_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 186: nip_number_dup per_all_people_f.per_information1%type;

182: type v_nip is table of number
183: index by binary_integer;
184:
185: nip_number v_nip;
186: nip_number_dup per_all_people_f.per_information1%type;
187:
188: cursor nip is
189: select per_information1
190: from per_all_people_f ppf

Line 190: from per_all_people_f ppf

186: nip_number_dup per_all_people_f.per_information1%type;
187:
188: cursor nip is
189: select per_information1
190: from per_all_people_f ppf
191: where ppf.business_group_id = p_business_group_id
192: and ppf.person_id <> nvl (p_person_id, 0)
193: and ppf.per_information1 = p_nip_number
194: and ppf.per_information7 = p_legal_employer

Line 594: Inputs : 1) Person id from per_all_people_f

590:
591: /**********************************************************************************************/
592: /*
593:
594: Inputs : 1) Person id from per_all_people_f
595: 2) Code of the type of Service. This code can be picked up from lookup EMPLOYEE_CATG
596:
597: Outputs : 1) Number of Years
598: 2) Number of Months

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 966: cursor csr_pemp_without_start_date(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
968: from PER_PREVIOUS_EMPLOYERS
969: where person_id=r_person_id
970: and employer_type='PREVIOUS'

Line 973: cursor csr_prev_emp_with_start_date(r_person_id per_all_people_f.person_id%type) is

969: where person_id=r_person_id
970: and employer_type='PREVIOUS'
971: and start_date is null;
972:
973: cursor csr_prev_emp_with_start_date(r_person_id per_all_people_f.person_id%type) is
974: select start_date ,end_date,period_months,period_days,period_years,employer_type
975: from PER_PREVIOUS_EMPLOYERS
976: where person_id=r_person_id
977: and employer_type in ('PREVIOUS','PARALLEL')

Line 996: l_person_id per_all_people_f.person_id%type;

992: l_prev_emp_table prev_emp_table;
993: l_key number ;
994: idx number := 0;
995: l_end_date date;
996: l_person_id per_all_people_f.person_id%type;
997:
998: l_temp_period_years number;
999: l_temp_period_months number;
1000: l_temp_period_days number;

Line 1214: FROM per_all_people_f pp

1210: SELECT 'Y'
1211: INTO l_status
1212: FROM sys.dual
1213: WHERE exists(SELECT '1'
1214: FROM per_all_people_f pp
1215: WHERE (p_person_id IS NULL
1216: OR p_person_id <> pp.person_id)
1217: AND p_national_identifier = pp.national_identifier
1218: AND pp.business_group_id +0 = p_business_group_id