eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IP_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

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 188: FROM pay_assignment_actions

184: AND paaf.effective_end_date;
185:
186: CURSOR get_tax_unit_id(p_asg_action_id IN NUMBER) IS
187: SELECT tax_unit_id
188: FROM pay_assignment_actions
189: WHERE assignment_action_id = p_asg_action_id;
190:
191: CURSOR c_get_employer_information(p_org_id IN NUMBER) IS
192: SELECT hou.name

Line 206: ,pay_assignment_actions paa

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
210: AND hoi.organization_id = hou.organization_id;

Line 228: FROM pay_assignment_actions paa,

224: ppf.middle_names,
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