DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_RUN_RESULTS

Line 1564: ,pay_run_results prr

1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf
1564: ,pay_run_results prr
1565: ,pay_run_result_values prrv1
1566: ,pay_element_classifications pec2
1567: ,pay_sub_classification_rules_f pscr
1568: where pet.element_type_id = piv1.element_type_id

Line 1600: from pay_run_results prr1,

1596: and prr.status in ('P','PA')
1597: and NOT EXISTS
1598: (
1599: select 1
1600: from pay_run_results prr1,
1601: pay_element_types_f pet1
1602: where prr1.assignment_action_id = paa.assignment_action_id
1603: and prr1.element_type_id = pet1.element_type_id
1604: and pet1.element_name in ('Retropay GT 12 Mths Amount')

Line 2469: ,pay_run_results prr

2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf
2467: ,pay_payroll_actions ppa
2468: ,pay_assignment_actions paa
2469: ,pay_run_results prr
2470: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
2471: AND ppa.action_type in ('R','Q','B','V','I')
2472: AND ppa.payroll_id = paf.payroll_id
2473: AND paa.assignment_id = c_assignment_id