APPS.PER_DIF_STMT_REPORT dependencies on PER_ALL_PEOPLE_F

Line 30: l_full_name per_all_people_f.full_name%TYPE;

26: l_where_estab VARCHAR2(500);
27: l_select VARCHAR2(500);
28: l_estab_id NUMBER;
29: l_emp_id NUMBER;
30: l_full_name per_all_people_f.full_name%TYPE;
31: l_emp_num per_all_people_f.employee_number%TYPE;
32: l_xml clob;
33: l_date_from date;
34: l_date_to date;

Line 31: l_emp_num per_all_people_f.employee_number%TYPE;

27: l_select VARCHAR2(500);
28: l_estab_id NUMBER;
29: l_emp_id NUMBER;
30: l_full_name per_all_people_f.full_name%TYPE;
31: l_emp_num per_all_people_f.employee_number%TYPE;
32: l_xml clob;
33: l_date_from date;
34: l_date_to date;
35: --

Line 70: l_select := 'select distinct per.person_id emp_id, estab.organization_id estab_id, per.full_name name, per.employee_number empnum from per_all_people_f per, per_all_assignments_f ass, pay_element_entries_f ent, '||

66: --
67: -- Get a list of employees for this establishment
68: -- and accrual plan, if any
69: -- Build the query dynamically
70: l_select := 'select distinct per.person_id emp_id, estab.organization_id estab_id, per.full_name name, per.employee_number empnum from per_all_people_f per, per_all_assignments_f ass, pay_element_entries_f ent, '||
71: 'pay_accrual_plans acc, hr_all_organization_units estab';
72: l_where := ' where per.person_id = ass.person_id and per.business_group_id = '||p_business_group_id||' and '|| '''' ||l_date_to|| ''''||' between per.effective_start_date '
73: ||'and per.effective_end_date and estab.business_group_id = per.business_group_id and ass.establishment_id = estab.organization_id '
74: ||'and ass.effective_end_date >= '|| '''' ||l_date_from|| ''''||' and ass.effective_start_date <= '|| '''' ||l_date_to|| ''''||' and ass.assignment_id = ent.assignment_id '

Line 291: from per_all_people_f per,

287: 'emp_hdr_asg_catg',
288: hr_general.decode_lookup('EMP_CAT', asg.employment_category),
289: asg.assignment_id,
290: asg.payroll_id
291: from per_all_people_f per,
292: per_addresses per_addr,
293: fnd_territories per_ft,
294: per_periods_of_service serv,
295: per_all_assignments_f asg,

Line 300: from per_all_people_f

296: per_collective_agreements col_agr
297: where per.person_id = p_emp_id
298: and asg.person_id = per.person_id
299: and per.effective_end_date = (select max(effective_end_date)
300: from per_all_people_f
301: where person_id = per.person_id
302: and effective_end_date >= p_date_from)
303: and asg.effective_end_date =(select max(effective_end_date)
304: from per_all_assignments_f

Line 367: per_all_people_f per,

363: Cursor csr_get_co_start is
364: select greatest(ent.effective_start_date, per.original_date_of_hire) co_start_date
365: from pay_element_entries_f ent,
366: per_all_assignments_f asg,
367: per_all_people_f per,
368: pay_accrual_plans acc
369: where acc.accrual_plan_id = p_accrual_plan_id
370: and per.person_id = p_emp_id
371: and asg.person_id = per.person_id

Line 373: from per_all_people_f

369: where acc.accrual_plan_id = p_accrual_plan_id
370: and per.person_id = p_emp_id
371: and asg.person_id = per.person_id
372: and per.effective_end_date = (select max(effective_end_date)
373: from per_all_people_f
374: where person_id = per.person_id
375: and effective_end_date >= p_date_from)
376: and asg.effective_end_date =(select max(effective_end_date)
377: from per_all_assignments_f