DBA Data[Home] [Help]

APPS.PAY_MX_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 239: ,pay_assignment_actions paa

235: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
236: SELECT hl.region_1
237: FROM hr_locations_all hl
238: ,per_all_assignments_f paf
239: ,pay_assignment_actions paa
240: ,fnd_sessions fs
241: WHERE paa.assignment_action_id = cp_assignment_action_id
242: AND fs.session_id = userenv('sessionid')
243: AND paf.assignment_id = paa.assignment_id

Line 566: FROM pay_assignment_actions

562: WHERE hou.organization_id = p_tax_unit_id;
563:
564: CURSOR get_tax_unit_id(p_asg_action_id number) IS
565: SELECT tax_unit_id
566: FROM pay_assignment_actions
567: WHERE assignment_action_id = p_asg_action_id;
568:
569: CURSOR c_get_employer_information(p_org_id number) IS
570: SELECT hoi.org_information1

Line 594: FROM pay_assignment_actions paa,

590: ppf.middle_names,
591: ppf.order_name,
592: ppf.full_name,
593: paf.payroll_id
594: FROM pay_assignment_actions paa,
595: pay_payroll_actions ppa,
596: per_assignments_f paf,
597: per_people_f ppf
598: WHERE paa.assignment_action_id = p_asg_action_id