APPS.PAY_IE_WNU_EDI dependencies on PAY_PAYROLL_ACTIONS

Line 136: 'pay_payroll_actions ppa '||

132: -- the string, and the statement must be, order by person_id
133: --
134: sqlstr := 'select distinct person_id '||
135: 'from per_people_f ppf, '||
136: 'pay_payroll_actions ppa '||
137: 'where ppa.payroll_action_id = :payroll_action_id '||
138: 'and ppa.business_group_id = ppf.business_group_id '||
139: 'order by ppf.person_id';
140: --

Line 163: pay_payroll_actions ppa,

159: cursor csr_state(p_payroll_id NUMBER, p_emp_ref VARCHAR2, p_assignment_set_id NUMBER) IS
160: select asg.assignment_id assignment_id,
161: ppa.effective_date effective_date
162: from per_all_assignments_f asg,
163: pay_payroll_actions ppa,
164: per_all_people_f pap,
165: per_periods_of_service serv,
166: -- hr_organization_information hoi,
167: pay_all_payrolls_f pay,

Line 322: pay_payroll_actions ppa,

318: cursor csr_state(p_payroll_id NUMBER, p_emp_ref VARCHAR2, p_assignment_set_id NUMBER) is
319: select asg.assignment_id assignment_id,
320: ppa.effective_date effective_date
321: from per_all_assignments_f asg,
322: pay_payroll_actions ppa,
323: per_all_people_f pap,
324: per_periods_of_service serv,
325: per_assignment_extra_info aei,
326: -- hr_organization_information hoi,