APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_TYPES_F

Line 2432: pay_run_types_f prt

2428: p_effective_date DATE ) IS
2429: SELECT paa.assignment_action_id child_assignment_action_id,
2430: 'S' run_type
2431: FROM pay_assignment_actions paa,
2432: pay_run_types_f prt
2433: WHERE paa.source_action_id = p_master_assignment_action
2434: AND paa.payroll_action_id = p_payroll_action_id
2435: AND paa.assignment_id = p_assignment_id
2436: AND paa.run_type_id = prt.run_type_id

Line 2448: pay_run_types_f prt1

2444: WHERE paa.payroll_action_id = p_payroll_action_id
2445: AND paa.assignment_id = p_assignment_id
2446: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2447: FROM pay_assignment_actions paa1,
2448: pay_run_types_f prt1
2449: WHERE prt1.run_type_id = paa1.run_type_id
2450: AND prt1.run_method IN ('N','P')
2451: AND paa1.payroll_action_id = p_payroll_action_id
2452: AND paa1.assignment_id = p_assignment_id

Line 2463: pay_run_types_f prt

2459: p_effective_date DATE ) IS
2460: /*SELECT paa.assignment_action_id child_assignment_action_id,
2461: 'S' run_type
2462: FROM pay_assignment_actions paa,
2463: pay_run_types_f prt
2464: WHERE paa.run_type_id = prt.run_type_id
2465: AND prt.run_method = 'S'
2466: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2467: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)

Line 2483: pay_run_types_f prt

2479: -- Bug Fix 4260031
2480: SELECT paa.assignment_action_id child_assignment_action_id,
2481: prt.run_method run_type
2482: FROM pay_assignment_actions paa,
2483: pay_run_types_f prt
2484: WHERE paa.run_type_id = prt.run_type_id
2485: AND prt.run_method IN ('N','P')
2486: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2487: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */

Line 2508: pay_run_types_f prt

2504: p_effective_date DATE) IS
2505: SELECT paa.assignment_action_id np_assignment_action_id,
2506: prt.run_method
2507: FROM pay_assignment_actions paa,
2508: pay_run_types_f prt
2509: WHERE paa.source_action_id = p_assignment_action_id
2510: AND paa.payroll_action_id = p_payroll_action_id
2511: AND paa.assignment_id = p_assignment_id
2512: AND paa.run_type_id = prt.run_type_id

Line 2523: pay_run_types_f prt

2519: p_effective_date DATE) IS
2520: SELECT paa.assignment_action_id np_assignment_action_id,
2521: prt.run_method
2522: FROM pay_assignment_actions paa,
2523: pay_run_types_f prt
2524: WHERE paa.run_type_id = prt.run_type_id
2525: AND prt.run_method IN ('N','P')
2526: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2527: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)