DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2097: pay_run_types_f prt

2093: p_effective_date DATE ) IS
2094: SELECT paa.assignment_action_id child_assignment_action_id,
2095: 'S' run_type
2096: FROM pay_assignment_actions paa,
2097: pay_run_types_f prt
2098: WHERE paa.source_action_id = p_master_assignment_action
2099: AND paa.payroll_action_id = p_payroll_action_id
2100: AND paa.assignment_id = p_assignment_id
2101: AND paa.run_type_id = prt.run_type_id

Line 2113: pay_run_types_f prt1

2109: WHERE paa.payroll_action_id = p_payroll_action_id
2110: AND paa.assignment_id = p_assignment_id
2111: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2112: FROM pay_assignment_actions paa1,
2113: pay_run_types_f prt1
2114: WHERE prt1.run_type_id = paa1.run_type_id
2115: AND prt1.run_method IN ('N','P')
2116: AND paa1.payroll_action_id = p_payroll_action_id
2117: AND paa1.assignment_id = p_assignment_id

Line 2129: pay_run_types_f prt

2125: p_effective_date DATE) IS
2126: SELECT paa.assignment_action_id np_assignment_action_id,
2127: prt.run_method
2128: FROM pay_assignment_actions paa,
2129: pay_run_types_f prt
2130: WHERE paa.source_action_id = p_assignment_action_id
2131: AND paa.payroll_action_id = p_payroll_action_id
2132: AND paa.assignment_id = p_assignment_id
2133: AND paa.run_type_id = prt.run_type_id