DBA Data[Home] [Help]

APPS.PAY_IP_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 180: FROM per_all_assignments_f paaf, pay_assignment_actions paa

176: WHERE hou.organization_id = p_tax_unit_id;
177:
178: CURSOR c_get_bus_group_id(cp_assignment_action_id IN NUMBER) IS
179: SELECT paaf.business_group_id
180: FROM per_all_assignments_f paaf, pay_assignment_actions paa
181: WHERE paa.assignment_action_id = cp_assignment_action_id
182: AND paa.assignment_id = paaf.assignment_id
183: AND sysdate BETWEEN paaf.effective_start_date
184: AND paaf.effective_end_date;

Line 205: ,per_all_assignments_f paaf

201: SELECT DISTINCT hou.name
202: ,hou.location_id
203: FROM hr_organization_units hou
204: ,hr_organization_information hoi
205: ,per_all_assignments_f paaf
206: ,pay_assignment_actions paa
207: WHERE paa.assignment_action_id = cp_assignment_action_id
208: AND paa.assignment_id = paaf.assignment_id
209: AND hou.organization_id = paaf.organization_id