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 640: Inputs : 1) Person id from per_all_people_f

636:
637: /**********************************************************************************************/
638: /*
639:
640: Inputs : 1) Person id from per_all_people_f
641: 2) Code of the type of Service. This code can be picked up from lookup EMPLOYEE_CATG
642:
643: Outputs : 1) Number of Years
644: 2) Number of Months

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 1012: cursor csr_pemp_without_start_date(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
1014: from PER_PREVIOUS_EMPLOYERS
1015: where person_id=r_person_id
1016: and employer_type='PREVIOUS'

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

1015: where person_id=r_person_id
1016: and employer_type='PREVIOUS'
1017: and start_date is null;
1018:
1019: cursor csr_prev_emp_with_start_date(r_person_id per_all_people_f.person_id%type) is
1020: select start_date ,end_date,period_months,period_days,period_years,employer_type
1021: from PER_PREVIOUS_EMPLOYERS
1022: where person_id=r_person_id
1023: and employer_type in ('PREVIOUS','PARALLEL')

Line 1042: l_person_id per_all_people_f.person_id%type;

1038: l_prev_emp_table prev_emp_table;
1039: l_key number ;
1040: idx number := 0;
1041: l_end_date date;
1042: l_person_id per_all_people_f.person_id%type;
1043:
1044: l_temp_period_years number;
1045: l_temp_period_months number;
1046: l_temp_period_days number;

Line 1257: FROM per_all_people_f pp

1253: SELECT 'Y'
1254: INTO l_status
1255: FROM sys.dual
1256: WHERE exists(SELECT '1'
1257: FROM per_all_people_f pp
1258: WHERE (p_person_id IS NULL
1259: OR p_person_id <> pp.person_id)
1260: AND p_national_identifier = pp.national_identifier
1261: AND pp.business_group_id +0 = p_business_group_id