DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2025: pay_run_types_f prt

2021: p_effective_date DATE ) IS
2022: SELECT paa.assignment_action_id child_assignment_action_id,
2023: 'S' run_type
2024: FROM pay_assignment_actions paa,
2025: pay_run_types_f prt
2026: WHERE paa.source_action_id = p_master_assignment_action
2027: AND paa.payroll_action_id = p_payroll_action_id
2028: AND paa.assignment_id = p_assignment_id
2029: AND paa.run_type_id = prt.run_type_id

Line 2041: pay_run_types_f prt1

2037: WHERE paa.payroll_action_id = p_payroll_action_id
2038: AND paa.assignment_id = p_assignment_id
2039: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2040: FROM pay_assignment_actions paa1,
2041: pay_run_types_f prt1
2042: WHERE prt1.run_type_id = paa1.run_type_id
2043: AND prt1.run_method IN ('N','P')
2044: AND paa1.payroll_action_id = p_payroll_action_id
2045: AND paa1.assignment_id = p_assignment_id

Line 2057: pay_run_types_f prt

2053: p_effective_date DATE) IS
2054: SELECT paa.assignment_action_id np_assignment_action_id,
2055: prt.run_method
2056: FROM pay_assignment_actions paa,
2057: pay_run_types_f prt
2058: WHERE paa.source_action_id = p_assignment_action_id
2059: AND paa.payroll_action_id = p_payroll_action_id
2060: AND paa.assignment_id = p_assignment_id
2061: AND paa.run_type_id = prt.run_type_id