eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_PTO_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 564: l_action_sequence PAY_ASSIGNMENT_ACTIONS.ACTION_SEQUENCE%TYPE;

560: l_previous_paid_absences Number := 0;
561: l_current_paid_absences Number := 0;
562: l_previous_paid_absences_retro Number := 0;
563: l_current_paid_absences_retro Number := 0;
564: l_action_sequence PAY_ASSIGNMENT_ACTIONS.ACTION_SEQUENCE%TYPE;
565: --
566: l_booked_m Number; l_booked_s Number; l_booked_y Number; l_booked_c Number; l_booked_p Number;
567: --
568: l_term_payment Number;

Line 602: from pay_assignment_actions paa

598: -- all booked (element entries).
599: --
600: CURSOR csr_previous_action_sequence is
601: select max(paa.action_sequence)
602: from pay_assignment_actions paa
603: ,pay_payroll_actions ppa
604: where ppa.payroll_action_id = paa.payroll_action_id
605: and paa.assignment_id = p_assignment_id
606: and p_paid_days_to >= ppa.effective_date

Line 615: ,pay_assignment_actions paa

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
619: and prrv_days.input_value_id = l_fr_pay_info.pay_total_days_input_ID

Line 639: ,pay_assignment_actions paa

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
643: and prrv_days.input_value_id = l_fr_pay_r_info.pay_total_days_input_ID

Line 663: ,pay_assignment_actions paa

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
667: and prrv_days.input_value_id = l_fr_pay_info.pay_total_days_input_ID

Line 684: ,pay_assignment_actions paa

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
688: and prrv_days.input_value_id = l_fr_pay_r_info.pay_total_days_input_ID

Line 702: from pay_assignment_actions paa

698: -- Get the minimum action sequence in this accrual year
699: --
700: CURSOR csr_current_action_sequence is
701: select min(paa.action_sequence)
702: from pay_assignment_actions paa
703: ,pay_payroll_actions ppa
704: where ppa.payroll_action_id = paa.payroll_action_id
705: and paa.assignment_id = p_assignment_id
706: and p_paid_days_to <= ppa.effective_date

Line 711: from pay_assignment_actions paa

707: and ppa.action_type in ('Q','R');
708:
709: CURSOR csr_previous_and_current_seq is
710: select max(paa.action_sequence)
711: from pay_assignment_actions paa
712: ,pay_payroll_actions ppa
713: where ppa.payroll_action_id = paa.payroll_action_id
714: and paa.assignment_id = p_assignment_id
715: and p_paid_days_to >= ppa.effective_date

Line 725: ,pay_assignment_actions paa

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
729: and prrv_days.input_value_id = l_fr_pay_info.pay_total_days_input_ID

Line 747: ,pay_assignment_actions paa

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
751: and prrv_days.input_value_id = l_fr_pay_r_info.pay_total_days_input_ID

Line 771: ,pay_assignment_actions paa

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
775: and prrv_days.input_value_id = l_fr_plan_info.term_days_iv_ID

Line 1338: ,pay_assignment_actions paa

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
1342: and prrv_flag.run_result_id = prr.run_result_id

Line 1368: ,pay_assignment_actions paa

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
1372: and prrv_flag.run_result_id = prr.run_result_id

Line 1394: ,pay_assignment_actions paa

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
1398: and prrv_pay.input_value_id = l_fr_pay_info.pay_reg_payment_input_ID

Line 1416: ,pay_assignment_actions paa

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
1420: and prrv_pay.input_value_id = l_fr_pay_r_info.pay_reg_payment_input_ID

Line 1443: ,pay_assignment_actions paa

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
1447: and prrv_pay.input_value_id = pivf_pay.input_value_id

Line 1627: l_action_sequence PAY_ASSIGNMENT_ACTIONS.ACTION_SEQUENCE%TYPE := null;

1623: l_total_days_paid_r Number := 0;
1624: l_total_payment_made_r Number := 0;
1625: l_previous_reg_payments Number := 0;
1626: l_term_reg_payments Number := 0;
1627: l_action_sequence PAY_ASSIGNMENT_ACTIONS.ACTION_SEQUENCE%TYPE := null;
1628: --
1629: l_fr_plan_info g_fr_plan_info;
1630: l_fr_pay_info g_fr_pay_info;
1631: l_fr_pay_r_info g_fr_pay_info;

Line 1651: ,pay_assignment_actions paa

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
1655: and prrv_pay.input_value_id = pivf_pay.input_value_id

Line 1687: ,pay_assignment_actions paa

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
1691: and prrv_pay.input_value_id = l_fr_pay_info.pay_reg_payment_input_ID

Line 1714: ,pay_assignment_actions paa

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
1718: and prrv_accrual.run_result_id = prr.run_result_id

Line 1738: ,pay_assignment_actions paa

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
1742: and prrv_accrual.run_result_id = prr.run_result_id

Line 1757: from pay_assignment_actions paa

1753: and prrv_accrual.result_value between fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_start)
1754: and fnd_date.date_to_canonical(l_fr_plan_info.accrual_year_end);
1755: CURSOR csr_action_sequence_all_paid is
1756: select max(paa.action_sequence)
1757: from pay_assignment_actions paa
1758: ,pay_payroll_Actions ppa
1759: where ppa.payroll_action_id = paa.payroll_action_id
1760: and paa.assignment_id = p_assignment_id;
1761: begin

Line 2161: from pay_assignment_actions paa,

2157: --
2158: CURSOR csr_get_assignment_action (l_assignment_id number) is
2159: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2160: paa.assignment_action_id),16))
2161: from pay_assignment_actions paa,
2162: pay_payroll_actions ppa
2163: where paa.assignment_id = l_assignment_id
2164: and ppa.payroll_action_id = paa.payroll_action_id
2165: and ppa.effective_date between l_fr_plan_info.accrual_year_start and l_fr_plan_info.accrual_year_end

Line 2189: ,pay_assignment_actions ASSACT

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
2193: ,per_time_periods PTP

Line 2190: ,pay_assignment_actions BAL_ASSACT

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
2193: ,per_time_periods PTP
2194: where BAL_ASSACT.assignment_action_id = l_latest_aa /*B1 */

Line 4396: ,pay_assignment_actions paa

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
4400: and prrvm.input_value_id in(l_days_input_id, l_protected_days_input_id)