APPS.PAY_FR_PTO_PKG dependencies on PAY_RUN_RESULTS

Line 614: ,pay_run_results prr

610: select sum(prrv_days.result_value)
611: from pay_run_result_values prrv_days
612: ,pay_run_result_values prrv_accrual
613: ,pay_run_result_values prrv_plan
614: ,pay_run_results prr
615: ,pay_assignment_actions paa
616: where prrv_days.run_result_id = prr.run_result_id
617: and prrv_plan.run_result_id = prr.run_result_id
618: and prrv_accrual.run_result_id = prr.run_result_id

Line 638: ,pay_run_results prr

634: select sum(prrv_days.result_value)
635: from pay_run_result_values prrv_days
636: ,pay_run_result_values prrv_accrual
637: ,pay_run_result_values prrv_plan
638: ,pay_run_results prr
639: ,pay_assignment_actions paa
640: where prrv_days.run_result_id = prr.run_result_id
641: and prrv_plan.run_result_id = prr.run_result_id
642: and prrv_accrual.run_result_id = prr.run_result_id

Line 662: ,pay_run_results prr

658: select sum(prrv_days.result_value)
659: from pay_run_result_values prrv_days
660: ,pay_run_result_values prrv_accrual
661: ,pay_run_result_values prrv_plan
662: ,pay_run_results prr
663: ,pay_assignment_actions paa
664: where prrv_days.run_result_id = prr.run_result_id
665: and prrv_plan.run_result_id = prr.run_result_id
666: and prrv_accrual.run_result_id = prr.run_result_id

Line 683: ,pay_run_results prr

679: select sum(prrv_days.result_value)
680: from pay_run_result_values prrv_days
681: ,pay_run_result_values prrv_accrual
682: ,pay_run_result_values prrv_plan
683: ,pay_run_results prr
684: ,pay_assignment_actions paa
685: where prrv_days.run_result_id = prr.run_result_id
686: and prrv_plan.run_result_id = prr.run_result_id
687: and prrv_accrual.run_result_id = prr.run_result_id

Line 724: ,pay_run_results prr

720: select sum(prrv_days.result_value)
721: from pay_run_result_values prrv_days
722: ,pay_run_result_values prrv_accrual
723: ,pay_run_result_values prrv_plan
724: ,pay_run_results prr
725: ,pay_assignment_actions paa
726: where prrv_days.run_result_id = prr.run_result_id
727: and prrv_plan.run_result_id = prr.run_result_id
728: and prrv_accrual.run_result_id = prr.run_result_id

Line 746: ,pay_run_results prr

742: select sum(prrv_days.result_value)
743: from pay_run_result_values prrv_days
744: ,pay_run_result_values prrv_accrual
745: ,pay_run_result_values prrv_plan
746: ,pay_run_results prr
747: ,pay_assignment_actions paa
748: where prrv_days.run_result_id = prr.run_result_id
749: and prrv_plan.run_result_id = prr.run_result_id
750: and prrv_accrual.run_result_id = prr.run_result_id

Line 770: ,pay_run_results prr

766: cursor csr_get_paid_days is
767: select sum(prrv_days.result_value)
768: from pay_run_result_values prrv_days
769: ,pay_run_result_values prrv_accrual
770: ,pay_run_results prr
771: ,pay_assignment_actions paa
772: ,pay_payroll_actions ppa
773: where prrv_days.run_result_id = prr.run_result_id
774: and prrv_accrual.run_result_id = prr.run_result_id

Line 1337: ,pay_run_results prr

1333: ,pay_run_result_values prrv_pay
1334: ,pay_run_result_values prrv_accrual
1335: ,pay_run_result_values prrv_flag
1336: ,pay_run_result_values prrv_plan
1337: ,pay_run_results prr
1338: ,pay_assignment_actions paa
1339: where prrv_days.run_result_id = prr.run_result_id
1340: and prrv_pay.run_result_id = prr.run_result_id
1341: and prrv_plan.run_result_id = prr.run_result_id

Line 1367: ,pay_run_results prr

1363: ,pay_run_result_values prrv_pay
1364: ,pay_run_result_values prrv_accrual
1365: ,pay_run_result_values prrv_flag
1366: ,pay_run_result_values prrv_plan
1367: ,pay_run_results prr
1368: ,pay_assignment_actions paa
1369: where prrv_days.run_result_id = prr.run_result_id
1370: and prrv_pay.run_result_id = prr.run_result_id
1371: and prrv_plan.run_result_id = prr.run_result_id

Line 1393: ,pay_run_results prr

1389: select sum(prrv_pay.result_value)
1390: from pay_run_result_values prrv_pay
1391: ,pay_run_result_values prrv_accrual
1392: ,pay_run_result_values prrv_plan
1393: ,pay_run_results prr
1394: ,pay_assignment_actions paa
1395: where prrv_pay.run_result_id = prr.run_result_id
1396: and prrv_plan.run_result_id = prr.run_result_id
1397: and prrv_accrual.run_result_id = prr.run_result_id

Line 1415: ,pay_run_results prr

1411: select sum(prrv_pay.result_value)
1412: from pay_run_result_values prrv_pay
1413: ,pay_run_result_values prrv_accrual
1414: ,pay_run_result_values prrv_plan
1415: ,pay_run_results prr
1416: ,pay_assignment_actions paa
1417: where prrv_pay.run_result_id = prr.run_result_id
1418: and prrv_plan.run_result_id = prr.run_result_id
1419: and prrv_accrual.run_result_id = prr.run_result_id

Line 1442: ,pay_run_results prr

1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay
1440: ,pay_input_values_f pivf_accrual
1441: ,pay_input_values_f pivf_plan
1442: ,pay_run_results prr
1443: ,pay_assignment_actions paa
1444: where prrv_pay.run_result_id = prr.run_result_id
1445: and prrv_plan.run_result_id = prr.run_result_id
1446: and prrv_accrual.run_result_id = prr.run_result_id

Line 1650: ,pay_run_results prr

1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay
1648: ,pay_input_values_f pivf_accrual
1649: ,pay_input_values_f pivf_plan
1650: ,pay_run_results prr
1651: ,pay_assignment_actions paa
1652: where prrv_pay.run_result_id = prr.run_result_id
1653: and prrv_plan.run_result_id = prr.run_result_id
1654: and prrv_accrual.run_result_id = prr.run_result_id

Line 1686: ,pay_run_results prr

1682: select sum(prrv_pay.result_value)
1683: from pay_run_result_values prrv_pay
1684: ,pay_run_result_values prrv_accrual
1685: ,pay_run_result_values prrv_plan
1686: ,pay_run_results prr
1687: ,pay_assignment_actions paa
1688: where prrv_pay.run_result_id = prr.run_result_id
1689: and prrv_plan.run_result_id = prr.run_result_id
1690: and prrv_accrual.run_result_id = prr.run_result_id

Line 1713: ,pay_run_results prr

1709: from pay_run_result_values prrv_days
1710: ,pay_run_result_values prrv_pay
1711: ,pay_run_result_values prrv_accrual
1712: ,pay_run_result_values prrv_plan
1713: ,pay_run_results prr
1714: ,pay_assignment_actions paa
1715: where prrv_days.run_result_id = prr.run_result_id
1716: and prrv_pay.run_result_id = prr.run_result_id
1717: and prrv_plan.run_result_id = prr.run_result_id

Line 1737: ,pay_run_results prr

1733: from pay_run_result_values prrv_days
1734: ,pay_run_result_values prrv_pay
1735: ,pay_run_result_values prrv_accrual
1736: ,pay_run_result_values prrv_plan
1737: ,pay_run_results prr
1738: ,pay_assignment_actions paa
1739: where prrv_days.run_result_id = prr.run_result_id
1740: and prrv_pay.run_result_id = prr.run_result_id
1741: and prrv_plan.run_result_id = prr.run_result_id

Line 2188: ,pay_run_results RR

2184: Select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
2185: from
2186: pay_run_result_values TARGET
2187: ,pay_balance_feeds_f FEED
2188: ,pay_run_results RR
2189: ,pay_assignment_actions ASSACT
2190: ,pay_assignment_actions BAL_ASSACT
2191: ,pay_payroll_actions PACT
2192: ,pay_payroll_actions BACT

Line 4395: ,pay_run_results prr

4391: select sum(decode(prrvm.input_value_id,l_days_input_id, prrvm.result_value))
4392: ,sum(decode(prrvm.input_value_id,l_protected_days_input_id, prrvm.result_value))
4393: from pay_run_result_values prrvm
4394: ,pay_run_result_values prrva
4395: ,pay_run_results prr
4396: ,pay_assignment_actions paa
4397: ,pay_payroll_actions ppa
4398: where prrvm.run_result_id = prr.run_result_id
4399: and prrva.run_result_id = prr.run_result_id