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_NL_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2914: ,pay_run_types_f prt

2910: ,p_assignment_id NUMBER
2911: ,p_effective_date DATE) IS
2912: SELECT paa.assignment_action_id np_assignment_action_id
2913: FROM pay_assignment_actions paa
2914: ,pay_run_types_f prt
2915: WHERE paa.source_action_id = p_assignment_action_id
2916: AND paa.payroll_action_id = p_payroll_action_id
2917: AND paa.assignment_id = p_assignment_id
2918: AND paa.run_type_id = prt.run_type_id

Line 3881: ,pay_run_types_f prt

3877: ,p_assignment_id NUMBER
3878: ,p_effective_date DATE) IS
3879: SELECT paa.assignment_action_id np_assignment_action_id
3880: FROM pay_assignment_actions paa
3881: ,pay_run_types_f prt
3882: WHERE paa.source_action_id = p_assignment_action_id
3883: AND paa.payroll_action_id = p_payroll_action_id
3884: AND paa.assignment_id = p_assignment_id
3885: AND paa.run_type_id = prt.run_type_id

Line 4498: ,pay_run_types_f prt

4494: ,p_assignment_id NUMBER
4495: ,p_effective_date DATE) IS
4496: SELECT paa.assignment_action_id np_assignment_action_id
4497: FROM pay_assignment_actions paa
4498: ,pay_run_types_f prt
4499: WHERE paa.source_action_id = p_assignment_action_id
4500: AND paa.payroll_action_id = p_payroll_action_id
4501: AND paa.assignment_id = p_assignment_id
4502: AND paa.run_type_id = prt.run_type_id

Line 6109: pay_run_types_f prt

6105: p_effective_date DATE ) IS
6106: SELECT paa.assignment_action_id child_assignment_action_id,
6107: 'S' run_type
6108: FROM pay_assignment_actions paa,
6109: pay_run_types_f prt
6110: WHERE paa.source_action_id = p_master_assignment_action
6111: AND paa.payroll_action_id = p_payroll_action_id
6112: AND paa.assignment_id = p_assignment_id
6113: AND paa.run_type_id = prt.run_type_id

Line 6126: pay_run_types_f prt1

6122: AND paa.assignment_id = p_assignment_id
6123: AND paa.action_sequence = (
6124: SELECT MAX(paa1.action_sequence)
6125: FROM pay_assignment_actions paa1,
6126: pay_run_types_f prt1
6127: WHERE prt1.run_type_id = paa1.run_type_id
6128: AND prt1.run_method IN ('N','P')
6129: AND paa1.payroll_action_id = p_payroll_action_id
6130: AND paa1.assignment_id = p_assignment_id

Line 6146: ,pay_run_types_f prt

6142: ,p_effective_date DATE) IS
6143: SELECT paa.assignment_action_id np_assignment_action_id,
6144: prt.run_method run_method
6145: FROM pay_assignment_actions paa
6146: ,pay_run_types_f prt
6147: WHERE paa.source_action_id = p_assignment_action_id
6148: AND paa.payroll_action_id = p_payroll_action_id
6149: AND paa.assignment_id = p_assignment_id
6150: AND paa.run_type_id = prt.run_type_id