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_MULTIASG dependencies on HR_LOOKUPS

Line 269: hr_lookups HR3

265: CURSOR asg_hours (p_assign_id NUMBER) IS
266: SELECT ASSIGN.normal_hours
267: FROM
268: per_all_assignments_f ASSIGN,
269: hr_lookups HR3
270: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
271: AND ASSIGN.effective_end_date
272: AND ASSIGN.assignment_id = p_assign_id
273: AND HR3.application_id (+)= 800

Line 285: , hr_lookups HR1

281: , per_pay_bases BASES
282: , pay_input_values_f INPUTV
283: , pay_element_types_f ETYPE
284: , pay_rates RATE
285: , hr_lookups HR1
286: , hr_lookups HR2
287: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
288: AND ASSIGN.effective_end_date
289: AND ASSIGN.assignment_id = p_assign_id

Line 286: , hr_lookups HR2

282: , pay_input_values_f INPUTV
283: , pay_element_types_f ETYPE
284: , pay_rates RATE
285: , hr_lookups HR1
286: , hr_lookups HR2
287: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
288: AND ASSIGN.effective_end_date
289: AND ASSIGN.assignment_id = p_assign_id
290: AND BASES.pay_basis_id (+)= ASSIGN.pay_basis_id

Line 309: hr_lookups HR3

305: CURSOR freq_code (p_assign_id NUMBER) IS
306: SELECT HR3.lookup_code
307: FROM
308: per_all_assignments_f ASSIGN,
309: hr_lookups HR3
310: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
311: AND ASSIGN.effective_end_date
312: AND ASSIGN.assignment_id = p_assign_id
313: AND HR3.application_id (+)= 800

Line 325: , hr_lookups HR1

321: , per_pay_bases BASES
322: , pay_input_values_f INPUTV
323: , pay_element_types_f ETYPE
324: , pay_rates RATE
325: , hr_lookups HR1
326: , hr_lookups HR2
327: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
328: AND ASSIGN.effective_end_date
329: AND ASSIGN.assignment_id = p_assign_id

Line 326: , hr_lookups HR2

322: , pay_input_values_f INPUTV
323: , pay_element_types_f ETYPE
324: , pay_rates RATE
325: , hr_lookups HR1
326: , hr_lookups HR2
327: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
328: AND ASSIGN.effective_end_date
329: AND ASSIGN.assignment_id = p_assign_id
330: AND BASES.pay_basis_id (+)= ASSIGN.pay_basis_id