APPS.PAY_FR_PTO_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 611: from pay_run_result_values prrv_days

607: and ppa.action_type in ('Q','R');
608:
609: CURSOR csr_previous_paid_absences is
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

Line 612: ,pay_run_result_values prrv_accrual

608:
609: CURSOR csr_previous_paid_absences is
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

Line 613: ,pay_run_result_values prrv_plan

609: CURSOR csr_previous_paid_absences is
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

Line 635: from pay_run_result_values prrv_days

631:
632:
633: CURSOR csr_previous_paid_absences_r is
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

Line 636: ,pay_run_result_values prrv_accrual

632:
633: CURSOR csr_previous_paid_absences_r is
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

Line 637: ,pay_run_result_values prrv_plan

633: CURSOR csr_previous_paid_absences_r is
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

Line 659: from pay_run_result_values prrv_days

655: --
656: -- Get the absences on or after the action sequence
657: CURSOR csr_current_paid_absences is
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

Line 660: ,pay_run_result_values prrv_accrual

656: -- Get the absences on or after the action sequence
657: CURSOR csr_current_paid_absences is
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

Line 661: ,pay_run_result_values prrv_plan

657: CURSOR csr_current_paid_absences is
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

Line 680: from pay_run_result_values prrv_days

676:
677: -- Get the absences on or after the action sequence
678: CURSOR csr_current_paid_absences_r is
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

Line 681: ,pay_run_result_values prrv_accrual

677: -- Get the absences on or after the action sequence
678: CURSOR csr_current_paid_absences_r is
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

Line 682: ,pay_run_result_values prrv_plan

678: CURSOR csr_current_paid_absences_r is
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

Line 721: from pay_run_result_values prrv_days

717:
718:
719: CURSOR csr_prev_and_current_paid_abs is
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

Line 722: ,pay_run_result_values prrv_accrual

718:
719: CURSOR csr_prev_and_current_paid_abs is
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

Line 723: ,pay_run_result_values prrv_plan

719: CURSOR csr_prev_and_current_paid_abs is
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

Line 743: from pay_run_result_values prrv_days

739: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
740:
741: CURSOR csr_prev_and_cur_paid_abs_r is
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

Line 744: ,pay_run_result_values prrv_accrual

740:
741: CURSOR csr_prev_and_cur_paid_abs_r is
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

Line 745: ,pay_run_result_values prrv_plan

741: CURSOR csr_prev_and_cur_paid_abs_r is
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

Line 768: from pay_run_result_values prrv_days

764: -- Termination processing - get sum of paid absences
765: --
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

Line 769: ,pay_run_result_values prrv_accrual

765: --
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

Line 1332: from pay_run_result_values prrv_days

1328: -- and holiday payments made
1329: -- in case of unregularized payments
1330: Cursor csr_paid_absence IS
1331: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1332: from pay_run_result_values prrv_days
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

Line 1333: ,pay_run_result_values prrv_pay

1329: -- in case of unregularized payments
1330: Cursor csr_paid_absence IS
1331: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1332: from pay_run_result_values prrv_days
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

Line 1334: ,pay_run_result_values prrv_accrual

1330: Cursor csr_paid_absence IS
1331: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1332: from pay_run_result_values prrv_days
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

Line 1335: ,pay_run_result_values prrv_flag

1331: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1332: from pay_run_result_values prrv_days
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

Line 1336: ,pay_run_result_values prrv_plan

1332: from pay_run_result_values prrv_days
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

Line 1362: from pay_run_result_values prrv_days

1358: -- and holiday payments made
1359: -- in case of unregularized payments retro
1360: Cursor csr_paid_absence_r IS
1361: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1362: from pay_run_result_values prrv_days
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

Line 1363: ,pay_run_result_values prrv_pay

1359: -- in case of unregularized payments retro
1360: Cursor csr_paid_absence_r IS
1361: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1362: from pay_run_result_values prrv_days
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

Line 1364: ,pay_run_result_values prrv_accrual

1360: Cursor csr_paid_absence_r IS
1361: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1362: from pay_run_result_values prrv_days
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

Line 1365: ,pay_run_result_values prrv_flag

1361: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
1362: from pay_run_result_values prrv_days
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

Line 1366: ,pay_run_result_values prrv_plan

1362: from pay_run_result_values prrv_days
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

Line 1390: from pay_run_result_values prrv_pay

1386: --
1387: -- Cursor to fetch all previous regularized payments
1388: Cursor csr_prev_reg_pymt IS
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

Line 1391: ,pay_run_result_values prrv_accrual

1387: -- Cursor to fetch all previous regularized payments
1388: Cursor csr_prev_reg_pymt IS
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

Line 1392: ,pay_run_result_values prrv_plan

1388: Cursor csr_prev_reg_pymt IS
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

Line 1412: from pay_run_result_values prrv_pay

1408:
1409: -- Cursor to fetch all previous regularized payments retro
1410: Cursor csr_prev_reg_pymt_r IS
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

Line 1413: ,pay_run_result_values prrv_accrual

1409: -- Cursor to fetch all previous regularized payments retro
1410: Cursor csr_prev_reg_pymt_r IS
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

Line 1414: ,pay_run_result_values prrv_plan

1410: Cursor csr_prev_reg_pymt_r IS
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

Line 1435: from pay_run_result_values prrv_pay

1431: --
1432: -- Cursor to fetch regularised payments on termination
1433: Cursor csr_fetch_term_reg_pymts IS
1434: select sum(nvl(prrv_pay.result_value,0)) payments
1435: from pay_run_result_values prrv_pay
1436: ,pay_run_result_values prrv_accrual
1437: ,pay_run_result_values prrv_plan
1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay

Line 1436: ,pay_run_result_values prrv_accrual

1432: -- Cursor to fetch regularised payments on termination
1433: Cursor csr_fetch_term_reg_pymts IS
1434: select sum(nvl(prrv_pay.result_value,0)) payments
1435: from pay_run_result_values prrv_pay
1436: ,pay_run_result_values prrv_accrual
1437: ,pay_run_result_values prrv_plan
1438: ,pay_element_types_f petf
1439: ,pay_input_values_f pivf_pay
1440: ,pay_input_values_f pivf_accrual

Line 1437: ,pay_run_result_values prrv_plan

1433: Cursor csr_fetch_term_reg_pymts IS
1434: select sum(nvl(prrv_pay.result_value,0)) payments
1435: from pay_run_result_values prrv_pay
1436: ,pay_run_result_values prrv_accrual
1437: ,pay_run_result_values prrv_plan
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

Line 1643: from pay_run_result_values prrv_pay

1639: --
1640:
1641: Cursor csr_fetch_term_reg_pymts IS
1642: select sum(nvl(prrv_pay.result_value,0)) payments
1643: from pay_run_result_values prrv_pay
1644: ,pay_run_result_values prrv_accrual
1645: ,pay_run_result_values prrv_plan
1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay

Line 1644: ,pay_run_result_values prrv_accrual

1640:
1641: Cursor csr_fetch_term_reg_pymts IS
1642: select sum(nvl(prrv_pay.result_value,0)) payments
1643: from pay_run_result_values prrv_pay
1644: ,pay_run_result_values prrv_accrual
1645: ,pay_run_result_values prrv_plan
1646: ,pay_element_types_f petf
1647: ,pay_input_values_f pivf_pay
1648: ,pay_input_values_f pivf_accrual

Line 1645: ,pay_run_result_values prrv_plan

1641: Cursor csr_fetch_term_reg_pymts IS
1642: select sum(nvl(prrv_pay.result_value,0)) payments
1643: from pay_run_result_values prrv_pay
1644: ,pay_run_result_values prrv_accrual
1645: ,pay_run_result_values prrv_plan
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

Line 1683: from pay_run_result_values prrv_pay

1679: --
1680:
1681: CURSOR csr_fetch_all_reg_payments is
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

Line 1684: ,pay_run_result_values prrv_accrual

1680:
1681: CURSOR csr_fetch_all_reg_payments is
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

Line 1685: ,pay_run_result_values prrv_plan

1681: CURSOR csr_fetch_all_reg_payments is
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

Line 1709: from pay_run_result_values prrv_days

1705: --
1706:
1707: CURSOR csr_fetch_all_paid_absences is
1708: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1710: ,pay_run_result_values prrv_pay

1706:
1707: CURSOR csr_fetch_all_paid_absences is
1708: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1711: ,pay_run_result_values prrv_accrual

1707: CURSOR csr_fetch_all_paid_absences is
1708: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1712: ,pay_run_result_values prrv_plan

1708: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1733: from pay_run_result_values prrv_days

1729: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1730: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1731: CURSOR csr_fetch_all_paid_absences_r is
1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1734: ,pay_run_result_values prrv_pay

1730: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1731: CURSOR csr_fetch_all_paid_absences_r is
1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1735: ,pay_run_result_values prrv_accrual

1731: CURSOR csr_fetch_all_paid_absences_r is
1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 1736: ,pay_run_result_values prrv_plan

1732: select sum(prrv_days.result_value), sum(prrv_pay.result_value)
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

Line 2186: pay_run_result_values TARGET

2182: -- in sub-query.
2183: CURSOR csr_get_balance_value is
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

Line 4393: from pay_run_result_values prrvm

4389: ,l_paid_element_type_id number, l_absence_attendance_input_ID number
4390: ,l_start_date date) is
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

Line 4394: ,pay_run_result_values prrva

4390: ,l_start_date date) is
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