APPS.PAY_NO_PAYPROC dependencies on PER_ALL_PEOPLE_F

Line 39: FROM per_all_people_f ppf,

35: BEGIN
36: l_proc_name := l_package || 'range_code';
37: hr_utility.set_location(l_proc_name, 10);
38: p_sqlstr := 'SELECT DISTINCT person_id
39: FROM per_all_people_f ppf,
40: pay_payroll_actions ppa
41: WHERE ppa.payroll_action_id = :payroll_action_id
42: AND ppa.business_group_id = ppf.business_group_id
43: ORDER BY ppf.person_id';

Line 83: per_all_people_f pap,

79: pay_payroll_actions pa2,
80: pay_payroll_actions pa1,
81: pay_pre_payments ppp,
82: pay_org_payment_methods_f OPM,
83: per_all_people_f pap,
84: hr_soft_coding_keyflex hsk,
85: pay_payment_types ppt
86:
87: WHERE pa1.payroll_action_id = p_payroll_action_id

Line 568: ,per_all_people_f pef

564: is
565: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
566: FROM per_addresses pad
567: ,per_all_assignments_f paf
568: ,per_all_people_f pef
569:
570: WHERE paf.assignment_id=p_assignment_id
571: and paf.person_id = pef.person_id
572: and pad.person_id= pef.person_id

Line 1415: FROM per_all_people_f ppf,

1411: /* cursor to get the emp no from the assignment_action_id */
1412: CURSOR csr_emp_no(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1413: IS
1414: SELECT ppf.employee_number
1415: FROM per_all_people_f ppf,
1416: per_all_assignments_f paf,
1417: pay_assignment_actions paa
1418: WHERE ppf.person_id=paf.person_id
1419: AND paf.assignment_id=paa.assignment_id