DBA Data[Home] [Help]

APPS.PAY_MX_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 220: ,pay_assignment_actions paa

216: CURSOR csr_get_jd (cp_assignment_action_id NUMBER) IS
217: SELECT hl.region_1
218: FROM hr_locations_all hl
219: ,per_all_assignments_f paf
220: ,pay_assignment_actions paa
221: ,fnd_sessions fs
222: WHERE paa.assignment_action_id = cp_assignment_action_id
223: AND fs.session_id = userenv('sessionid')
224: AND paf.assignment_id = paa.assignment_id

Line 547: FROM pay_assignment_actions

543: WHERE hou.organization_id = p_tax_unit_id;
544:
545: CURSOR get_tax_unit_id(p_asg_action_id number) IS
546: SELECT tax_unit_id
547: FROM pay_assignment_actions
548: WHERE assignment_action_id = p_asg_action_id;
549:
550: CURSOR c_get_employer_information(p_org_id number) IS
551: SELECT hoi.org_information1

Line 575: FROM pay_assignment_actions paa,

571: ppf.middle_names,
572: ppf.order_name,
573: ppf.full_name,
574: paf.payroll_id
575: FROM pay_assignment_actions paa,
576: pay_payroll_actions ppa,
577: per_assignments_f paf,
578: per_people_f ppf
579: WHERE paa.assignment_action_id = p_asg_action_id