DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_RUN_RESULTS

Line 2495: ,pay_run_results prr

2491: ,pay_element_classifications pec
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa
2494: ,per_assignments_f paaf
2495: ,pay_run_results prr
2496: ,pay_run_result_values prrv1
2497: ,pay_element_classifications pec2
2498: ,pay_sub_classification_rules_f pscr
2499: where paaf.assignment_id = c_assignment_id

Line 2533: from pay_run_results prr1,

2529: and prr.status in ('P','PA')
2530: and NOT EXISTS
2531: (
2532: select 1
2533: from pay_run_results prr1,
2534: pay_element_types_f pet1
2535: where prr1.assignment_action_id = paa.assignment_action_id
2536: and prr1.element_type_id = pet1.element_type_id
2537: and pet1.element_name in ('Retropay GT 12 Mths Amount',

Line 2604: ,pay_run_results prr

2600: FROM
2601: per_all_assignments_f paa
2602: ,pay_assignment_actions pac
2603: ,pay_payroll_actions ppa
2604: ,pay_run_results prr
2605: ,pay_element_types_f pet
2606: ,pay_input_values_f piv
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf