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_NO_ARCHIVE_RSEA dependencies on PER_ALL_ASSIGNMENTS_F

Line 343: ,per_all_assignments_f as1

339: ,pay_payroll_actions appa2
340: ,pay_assignment_actions act
341: ,pay_assignment_actions act1
342: ,pay_action_interlocks pai
343: ,per_all_assignments_f as1
344: ,hr_soft_coding_keyflex hsck
345: WHERE ppa.payroll_action_id = p_payroll_action_id
346: AND appa.effective_date BETWEEN l_canonical_start_date
347: AND l_canonical_end_date

Line 403: ,per_all_assignments_f as1

399: ,pay_payroll_actions appa2
400: ,pay_assignment_actions act
401: ,pay_assignment_actions act1
402: ,pay_action_interlocks pai
403: ,per_all_assignments_f as1
404: ,hr_soft_coding_keyflex hsck
405: WHERE ppa.payroll_action_id = p_payroll_action_id
406: AND appa.effective_date BETWEEN l_canonical_start_date
407: AND l_canonical_end_date

Line 433: FROM per_all_assignments_f asg1

429:
430: CURSOR csr_get_mun_num(p_assignment_id NUMBER,p_effective_date DATE )
431: IS
432: SELECT eev1.screen_entry_value screen_entry_value
433: FROM per_all_assignments_f asg1
434: ,per_all_assignments_f asg2
435: ,per_all_people_f per
436: ,pay_element_links_f el
437: ,pay_element_types_f et

Line 434: ,per_all_assignments_f asg2

430: CURSOR csr_get_mun_num(p_assignment_id NUMBER,p_effective_date DATE )
431: IS
432: SELECT eev1.screen_entry_value screen_entry_value
433: FROM per_all_assignments_f asg1
434: ,per_all_assignments_f asg2
435: ,per_all_people_f per
436: ,pay_element_links_f el
437: ,pay_element_types_f et
438: ,pay_input_values_f iv1