DBA Data[Home] [Help]

APPS.PAY_IP_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 229: pay_payroll_actions ppa,

225: ppf.order_name,
226: ppf.full_name,
227: paf.payroll_id
228: FROM pay_assignment_actions paa,
229: pay_payroll_actions ppa,
230: per_assignments_f paf,
231: per_people_f ppf
232: WHERE paa.assignment_action_id = p_asg_action_id
233: AND paa.payroll_action_id = ppa.payroll_action_id

Line 261: FROM hr_organization_information hoi, pay_payroll_actions ppa

257: AND organization_id = cp_business_group;
258:
259: CURSOR c_get_employer_info(cp_payroll_action_id IN NUMBER) IS
260: SELECT ppa.business_group_id, hoi.org_information9
261: FROM hr_organization_information hoi, pay_payroll_actions ppa
262: WHERE hoi.org_information_context = 'Business Group Information'
263: AND hoi.organization_id = ppa.business_group_id
264: AND ppa.payroll_action_id = cp_payroll_action_id;
265: