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 84: per_all_people_f pap,

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

Line 591: ,per_all_people_f pef

587: is
588: select ADDRESS_LINE1,ADDRESS_LINE2,POSTAL_CODE --,TOWN_OR_CITY
589: FROM per_addresses pad
590: ,per_all_assignments_f paf
591: ,per_all_people_f pef
592:
593: WHERE paf.assignment_id=p_assignment_id
594: and paf.person_id = pef.person_id
595: and pad.person_id= pef.person_id

Line 1439: FROM per_all_people_f ppf,

1435: /* cursor to get the emp no from the assignment_id for BETFOR22*/
1436: CURSOR csr_emp_no(v_act_id per_all_assignments_f.assignment_id%TYPE)
1437: IS
1438: SELECT ppf.employee_number
1439: FROM per_all_people_f ppf,
1440: per_all_assignments_f paf
1441: WHERE ppf.person_id=paf.person_id
1442: AND paf.assignment_id=v_act_id;
1443:

Line 1449: FROM per_all_people_f ppf,

1445: /* cursor to get the emp no from the assignment_action_id BETFOR23*/
1446: CURSOR csr_emp_no_1(v_asg_act_id pay_assignment_actions.assignment_action_id%TYPE)
1447: IS
1448: SELECT ppf.employee_number
1449: FROM per_all_people_f ppf,
1450: per_all_assignments_f paf,
1451: pay_assignment_actions paa
1452: WHERE ppf.person_id=paf.person_id
1453: AND paf.assignment_id=paa.assignment_id