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_SE_PAYSLIP_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 398: pay_assignment_actions act,

394: act1.assignment_action_id prepaid_action_id
395: FROM pay_payroll_actions ppa,
396: pay_payroll_actions appa,
397: pay_payroll_actions appa2,
398: pay_assignment_actions act,
399: pay_assignment_actions act1,
400: pay_action_interlocks pai,
401: per_all_assignments_f as1
402: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 399: pay_assignment_actions act1,

395: FROM pay_payroll_actions ppa,
396: pay_payroll_actions appa,
397: pay_payroll_actions appa2,
398: pay_assignment_actions act,
399: pay_assignment_actions act1,
400: pay_action_interlocks pai,
401: per_all_assignments_f as1
402: WHERE ppa.payroll_action_id = p_payroll_action_id
403: AND appa.consolidation_set_id = p_consolidation_id

Line 427: pay_assignment_actions act2,

423: -- Prepayments or Quickpay Prepayments
424: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
425: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
426: FROM pay_action_interlocks pai1,
427: pay_assignment_actions act2,
428: pay_payroll_actions appa3
429: WHERE pai1.locked_action_id = act.assignment_action_id
430: AND act2.assignment_action_id= pai1.locking_action_id
431: AND act2.payroll_action_id = appa3.payroll_action_id

Line 437: pay_assignment_actions act2,

433: AND appa3.action_status = 'C'
434: AND appa3.report_type = 'SE_ARCHIVE')
435: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
436: FROM pay_action_interlocks pai1,
437: pay_assignment_actions act2,
438: pay_payroll_actions appa3
439: WHERE pai1.locked_action_id = act.assignment_action_id
440: AND act2.assignment_action_id= pai1.locking_action_id
441: AND act2.payroll_action_id = appa3.payroll_action_id

Line 490: SELECT pay_assignment_actions_s.NEXTVAL

486: ,l_consolidation_set
487: ,l_canonical_start_date
488: ,l_canonical_end_date) LOOP
489: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
490: SELECT pay_assignment_actions_s.NEXTVAL
491: INTO l_actid
492: FROM dual;
493: --
494: g_index_assact := g_index_assact + 1;

Line 522: ,pay_assignment_actions prepay_assact

518: CURSOR csr_prepay_id IS
519: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
520: ,run_payact.date_earned date_earned
521: FROM pay_action_interlocks archive_intlck
522: ,pay_assignment_actions prepay_assact
523: ,pay_payroll_actions prepay_payact
524: ,pay_action_interlocks prepay_intlck
525: ,pay_assignment_actions run_assact
526: ,pay_payroll_actions run_payact

Line 525: ,pay_assignment_actions run_assact

521: FROM pay_action_interlocks archive_intlck
522: ,pay_assignment_actions prepay_assact
523: ,pay_payroll_actions prepay_payact
524: ,pay_action_interlocks prepay_intlck
525: ,pay_assignment_actions run_assact
526: ,pay_payroll_actions run_payact
527: ,pay_assignment_actions archive_assact
528: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
529: and archive_assact.payroll_action_id = p_payroll_action_id

Line 527: ,pay_assignment_actions archive_assact

523: ,pay_payroll_actions prepay_payact
524: ,pay_action_interlocks prepay_intlck
525: ,pay_assignment_actions run_assact
526: ,pay_payroll_actions run_payact
527: ,pay_assignment_actions archive_assact
528: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
529: and archive_assact.payroll_action_id = p_payroll_action_id
530: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
531: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 544: ,pay_assignment_actions prepay_assact

540: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
541: ,run_payact.date_earned date_earned
542: ,run_payact.payroll_action_id run_payact_id
543: FROM pay_action_interlocks archive_intlck
544: ,pay_assignment_actions prepay_assact
545: ,pay_payroll_actions prepay_payact
546: ,pay_action_interlocks prepay_intlck
547: ,pay_assignment_actions run_assact
548: ,pay_payroll_actions run_payact

Line 547: ,pay_assignment_actions run_assact

543: FROM pay_action_interlocks archive_intlck
544: ,pay_assignment_actions prepay_assact
545: ,pay_payroll_actions prepay_payact
546: ,pay_action_interlocks prepay_intlck
547: ,pay_assignment_actions run_assact
548: ,pay_payroll_actions run_payact
549: ,pay_assignment_actions archive_assact
550: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
551: and archive_assact.payroll_action_id = p_payroll_action_id

Line 549: ,pay_assignment_actions archive_assact

545: ,pay_payroll_actions prepay_payact
546: ,pay_action_interlocks prepay_intlck
547: ,pay_assignment_actions run_assact
548: ,pay_payroll_actions run_payact
549: ,pay_assignment_actions archive_assact
550: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
551: and archive_assact.payroll_action_id = p_payroll_action_id
552: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
553: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1400: pay_assignment_actions paa,

1396: pop.org_payment_method_name opm_name,
1397: ppttl.payment_type_name pay_type,
1398: ppp.value value
1399: FROM pay_org_payment_methods_f pop,
1400: pay_assignment_actions paa,
1401: pay_payment_types ppt,
1402: pay_payment_types_tl ppttl,
1403: pay_pre_payments ppp
1404: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1427: pay_assignment_actions paa,

1423: ppp.value value
1424: FROM pay_external_accounts pea,
1425: pay_org_payment_methods_f pop,
1426: pay_personal_payment_methods_f ppm,
1427: pay_assignment_actions paa,
1428: pay_payment_types ppt,
1429: pay_payment_types_tl ppttl,
1430: pay_pre_payments ppp
1431: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)

Line 1640: ,pay_assignment_actions paa

1636: ,p_assignment_action_id NUMBER) IS
1637: SELECT rrv.result_value ,rr.element_entry_id
1638: FROM pay_run_result_values rrv
1639: ,pay_run_results rr
1640: ,pay_assignment_actions paa
1641: ,pay_payroll_actions ppa
1642: WHERE rrv.input_value_id = p_iv_id
1643: AND rr.element_type_id = p_ele_type_id
1644: AND rr.run_result_id = rrv.run_result_id

Line 1659: ,pay_assignment_actions paa

1655: ,p_EE_ID NUMBER) IS
1656: SELECT rrv.result_value
1657: FROM pay_run_result_values rrv
1658: ,pay_run_results rr
1659: ,pay_assignment_actions paa
1660: ,pay_payroll_actions ppa
1661: WHERE rrv.input_value_id = p_iv_id
1662: AND rr.element_type_id = p_ele_type_id
1663: AND rr.run_result_id = rrv.run_result_id

Line 1692: ,pay_assignment_actions paa

1688: ,count(rrv.RUN_RESULT_ID) record_count
1689: ,rrv.result_value UNIT_PRICE
1690: FROM pay_run_result_values rrv
1691: ,pay_run_results rr
1692: ,pay_assignment_actions paa
1693: ,pay_payroll_actions ppa
1694: WHERE rrv.input_value_id = p_iv_id
1695: AND rr.element_type_id = p_ele_type_id
1696: AND rr.run_result_id = rrv.run_result_id

Line 1713: ,pay_assignment_actions paa

1709: ,rrv.result_value UNIT_PRICE
1710: FROM pay_run_result_values pr
1711: ,pay_run_result_values rrv
1712: ,pay_run_results rr
1713: ,pay_assignment_actions paa
1714: ,pay_payroll_actions ppa
1715: WHERE pr.input_value_id(+) = p_group_by
1716: AND rrv.input_value_id = p_iv_id
1717: AND rr.element_type_id = p_ele_type_id

Line 1735: ,pay_assignment_actions paa

1731: ,count(rrv.RUN_RESULT_ID) record_count
1732: ,rrv.result_value UNIT_PRICE
1733: FROM pay_run_result_values rrv
1734: ,pay_run_results rr
1735: ,pay_assignment_actions paa
1736: ,pay_payroll_actions ppa
1737: WHERE rrv.input_value_id = p_iv_id
1738: AND rr.element_type_id = p_ele_type_id
1739: AND rr.run_result_id = rrv.run_result_id

Line 1760: ,pay_assignment_actions paa

1756: ) IS
1757: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
1758: FROM pay_run_result_values rrv1
1759: ,pay_run_results rr1
1760: ,pay_assignment_actions paa
1761: ,pay_payroll_actions ppa
1762: ,pay_run_result_values rrv2
1763: ,pay_run_results rr2
1764: ,pay_run_result_values rrv3

Line 1794: ,pay_assignment_actions paa

1790: ) IS
1791: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
1792: FROM pay_run_result_values rrv1
1793: ,pay_run_results rr1
1794: ,pay_assignment_actions paa
1795: ,pay_payroll_actions ppa
1796: ,pay_run_result_values rrv2
1797: ,pay_run_results rr2
1798: ,pay_run_result_values rrv3

Line 2264: FROM pay_assignment_actions paa

2260: AND org_information1 = 'BALANCE';
2261: /* Cursor to retrieve Tax Unit Id for setting context */
2262: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2263: SELECT paa.tax_unit_id
2264: FROM pay_assignment_actions paa
2265: WHERE paa.assignment_action_id = p_run_assact_id;
2266: /* Cursor to fetch defined balance id */
2267: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2268: SELECT defined_balance_id

Line 2586: ,pay_assignment_actions prepay_assact

2582: ,run_assact.assignment_action_id run_assact_id
2583: ,run_payact.payroll_action_id run_payact_id
2584: ,run_payact.payroll_id payroll_id
2585: FROM pay_action_interlocks archive_intlck
2586: ,pay_assignment_actions prepay_assact
2587: ,pay_payroll_actions prepay_payact
2588: ,pay_action_interlocks prepay_intlck
2589: ,pay_assignment_actions run_assact
2590: ,pay_payroll_actions run_payact

Line 2589: ,pay_assignment_actions run_assact

2585: FROM pay_action_interlocks archive_intlck
2586: ,pay_assignment_actions prepay_assact
2587: ,pay_payroll_actions prepay_payact
2588: ,pay_action_interlocks prepay_intlck
2589: ,pay_assignment_actions run_assact
2590: ,pay_payroll_actions run_payact
2591: WHERE archive_intlck.locking_action_id = p_locking_action_id
2592: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2593: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2610: ,pay_assignment_actions paa

2606: ppa.effective_date effective_date,
2607: ptp.start_date start_date
2608: FROM per_time_periods ptp
2609: ,pay_payroll_actions ppa
2610: ,pay_assignment_actions paa
2611: WHERE ptp.payroll_id =ppa.payroll_id
2612: AND ppa.payroll_action_id =paa.payroll_action_id
2613: AND paa.assignment_action_id =p_assact_id
2614: AND ppa.payroll_action_id =p_pay_act_id

Line 2620: FROM pay_assignment_actions

2616: AND ptp.end_date;
2617: /* Cursor to retrieve Archive Payroll Action Id */
2618: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2619: SELECT payroll_action_id
2620: FROM pay_assignment_actions
2621: WHERE assignment_Action_id = p_assignment_action_id;
2622: /* Cursor to retrieve Tax Unit Id for setting context */
2623: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2624: SELECT paa.tax_unit_id

Line 2625: FROM pay_assignment_actions paa

2621: WHERE assignment_Action_id = p_assignment_action_id;
2622: /* Cursor to retrieve Tax Unit Id for setting context */
2623: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2624: SELECT paa.tax_unit_id
2625: FROM pay_assignment_actions paa
2626: WHERE paa.assignment_action_id = p_run_assact_id;
2627:
2628: l_tu_id NUMBER;
2629: l_archive_payact_id NUMBER;

Line 2893: ,pay_assignment_actions paa

2889: ,p_assignment_action_id NUMBER) IS
2890: SELECT rrv.result_value,rr.element_entry_id
2891: FROM pay_run_result_values rrv
2892: ,pay_run_results rr
2893: ,pay_assignment_actions paa
2894: ,pay_payroll_actions ppa
2895: WHERE rrv.input_value_id = p_iv_id
2896: AND rr.element_type_id = p_ele_type_id
2897: AND rr.run_result_id = rrv.run_result_id

Line 2912: ,pay_assignment_actions paa

2908: ,p_EE_ID NUMBER) IS
2909: SELECT rrv.result_value
2910: FROM pay_run_result_values rrv
2911: ,pay_run_results rr
2912: ,pay_assignment_actions paa
2913: ,pay_payroll_actions ppa
2914: WHERE rrv.input_value_id = p_iv_id
2915: AND rr.element_type_id = p_ele_type_id
2916: AND rr.run_result_id = rrv.run_result_id

Line 2943: ,pay_assignment_actions paa

2939: ,count(rrv.RUN_RESULT_ID) record_count
2940: ,rrv.result_value UNIT_PRICE
2941: FROM pay_run_result_values rrv
2942: ,pay_run_results rr
2943: ,pay_assignment_actions paa
2944: ,pay_payroll_actions ppa
2945: WHERE rrv.input_value_id = p_iv_id
2946: AND rr.element_type_id = p_ele_type_id
2947: AND rr.run_result_id = rrv.run_result_id

Line 2964: ,pay_assignment_actions paa

2960: ,rrv.result_value UNIT_PRICE
2961: FROM pay_run_result_values pr
2962: ,pay_run_result_values rrv
2963: ,pay_run_results rr
2964: ,pay_assignment_actions paa
2965: ,pay_payroll_actions ppa
2966: WHERE pr.input_value_id(+) = p_group_by
2967: AND rrv.input_value_id = p_iv_id
2968: AND rr.element_type_id = p_ele_type_id

Line 2984: ,pay_assignment_actions paa

2980: ,p_assignment_action_id NUMBER) IS
2981: SELECT sum(rrv.result_value) result_value
2982: FROM pay_run_result_values rrv
2983: ,pay_run_results rr
2984: ,pay_assignment_actions paa
2985: ,pay_payroll_actions ppa
2986: WHERE rrv.input_value_id = p_iv_id
2987: AND rr.element_type_id = p_ele_type_id
2988: AND rr.run_result_id = rrv.run_result_id

Line 3011: ,pay_assignment_actions paa

3007: ) IS
3008: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
3009: FROM pay_run_result_values rrv1
3010: ,pay_run_results rr1
3011: ,pay_assignment_actions paa
3012: ,pay_payroll_actions ppa
3013: ,pay_run_result_values rrv2
3014: ,pay_run_results rr2
3015: ,pay_run_result_values rrv3

Line 3045: ,pay_assignment_actions paa

3041: ) IS
3042: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
3043: FROM pay_run_result_values rrv1
3044: ,pay_run_results rr1
3045: ,pay_assignment_actions paa
3046: ,pay_payroll_actions ppa
3047: ,pay_run_result_values rrv2
3048: ,pay_run_results rr2
3049: ,pay_run_result_values rrv3

Line 3783: FROM pay_assignment_actions

3779: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3780: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
3781: AND paaf.assignment_id IN
3782: (SELECT DISTINCT assignment_id
3783: FROM pay_assignment_actions
3784: WHERE payroll_action_id= p_payroll_action_id );
3785:
3786:
3787: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS