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 1398: pay_assignment_actions paa,

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

Line 1425: pay_assignment_actions paa,

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

Line 1638: ,pay_assignment_actions paa

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

Line 1657: ,pay_assignment_actions paa

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

Line 1690: ,pay_assignment_actions paa

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

Line 1711: ,pay_assignment_actions paa

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

Line 1733: ,pay_assignment_actions paa

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

Line 1758: ,pay_assignment_actions paa

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

Line 1790: ,pay_assignment_actions paa

1786: ) IS
1787: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
1788: FROM pay_run_result_values rrv1
1789: ,pay_run_results rr1
1790: ,pay_assignment_actions paa
1791: ,pay_payroll_actions ppa
1792: ,pay_run_result_values rrv2
1793: ,pay_run_results rr2
1794: ,pay_run_result_values rrv3

Line 2252: FROM pay_assignment_actions paa

2248: AND org_information1 = 'BALANCE';
2249: /* Cursor to retrieve Tax Unit Id for setting context */
2250: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2251: SELECT paa.tax_unit_id
2252: FROM pay_assignment_actions paa
2253: WHERE paa.assignment_action_id = p_run_assact_id;
2254: /* Cursor to fetch defined balance id */
2255: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
2256: SELECT defined_balance_id

Line 2574: ,pay_assignment_actions prepay_assact

2570: ,run_assact.assignment_action_id run_assact_id
2571: ,run_payact.payroll_action_id run_payact_id
2572: ,run_payact.payroll_id payroll_id
2573: FROM pay_action_interlocks archive_intlck
2574: ,pay_assignment_actions prepay_assact
2575: ,pay_payroll_actions prepay_payact
2576: ,pay_action_interlocks prepay_intlck
2577: ,pay_assignment_actions run_assact
2578: ,pay_payroll_actions run_payact

Line 2577: ,pay_assignment_actions run_assact

2573: FROM pay_action_interlocks archive_intlck
2574: ,pay_assignment_actions prepay_assact
2575: ,pay_payroll_actions prepay_payact
2576: ,pay_action_interlocks prepay_intlck
2577: ,pay_assignment_actions run_assact
2578: ,pay_payroll_actions run_payact
2579: WHERE archive_intlck.locking_action_id = p_locking_action_id
2580: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2581: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2598: ,pay_assignment_actions paa

2594: ppa.effective_date effective_date,
2595: ptp.start_date start_date
2596: FROM per_time_periods ptp
2597: ,pay_payroll_actions ppa
2598: ,pay_assignment_actions paa
2599: WHERE ptp.payroll_id =ppa.payroll_id
2600: AND ppa.payroll_action_id =paa.payroll_action_id
2601: AND paa.assignment_action_id =p_assact_id
2602: AND ppa.payroll_action_id =p_pay_act_id

Line 2608: FROM pay_assignment_actions

2604: AND ptp.end_date;
2605: /* Cursor to retrieve Archive Payroll Action Id */
2606: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2607: SELECT payroll_action_id
2608: FROM pay_assignment_actions
2609: WHERE assignment_Action_id = p_assignment_action_id;
2610: /* Cursor to retrieve Tax Unit Id for setting context */
2611: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2612: SELECT paa.tax_unit_id

Line 2613: FROM pay_assignment_actions paa

2609: WHERE assignment_Action_id = p_assignment_action_id;
2610: /* Cursor to retrieve Tax Unit Id for setting context */
2611: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2612: SELECT paa.tax_unit_id
2613: FROM pay_assignment_actions paa
2614: WHERE paa.assignment_action_id = p_run_assact_id;
2615:
2616: l_tu_id NUMBER;
2617: l_archive_payact_id NUMBER;

Line 2881: ,pay_assignment_actions paa

2877: ,p_assignment_action_id NUMBER) IS
2878: SELECT rrv.result_value,rr.element_entry_id
2879: FROM pay_run_result_values rrv
2880: ,pay_run_results rr
2881: ,pay_assignment_actions paa
2882: ,pay_payroll_actions ppa
2883: WHERE rrv.input_value_id = p_iv_id
2884: AND rr.element_type_id = p_ele_type_id
2885: AND rr.run_result_id = rrv.run_result_id

Line 2900: ,pay_assignment_actions paa

2896: ,p_EE_ID NUMBER) IS
2897: SELECT rrv.result_value
2898: FROM pay_run_result_values rrv
2899: ,pay_run_results rr
2900: ,pay_assignment_actions paa
2901: ,pay_payroll_actions ppa
2902: WHERE rrv.input_value_id = p_iv_id
2903: AND rr.element_type_id = p_ele_type_id
2904: AND rr.run_result_id = rrv.run_result_id

Line 2931: ,pay_assignment_actions paa

2927: ,count(rrv.RUN_RESULT_ID) record_count
2928: ,rrv.result_value UNIT_PRICE
2929: FROM pay_run_result_values rrv
2930: ,pay_run_results rr
2931: ,pay_assignment_actions paa
2932: ,pay_payroll_actions ppa
2933: WHERE rrv.input_value_id = p_iv_id
2934: AND rr.element_type_id = p_ele_type_id
2935: AND rr.run_result_id = rrv.run_result_id

Line 2952: ,pay_assignment_actions paa

2948: ,rrv.result_value UNIT_PRICE
2949: FROM pay_run_result_values pr
2950: ,pay_run_result_values rrv
2951: ,pay_run_results rr
2952: ,pay_assignment_actions paa
2953: ,pay_payroll_actions ppa
2954: WHERE pr.input_value_id(+) = p_group_by
2955: AND rrv.input_value_id = p_iv_id
2956: AND rr.element_type_id = p_ele_type_id

Line 2972: ,pay_assignment_actions paa

2968: ,p_assignment_action_id NUMBER) IS
2969: SELECT sum(rrv.result_value) result_value
2970: FROM pay_run_result_values rrv
2971: ,pay_run_results rr
2972: ,pay_assignment_actions paa
2973: ,pay_payroll_actions ppa
2974: WHERE rrv.input_value_id = p_iv_id
2975: AND rr.element_type_id = p_ele_type_id
2976: AND rr.run_result_id = rrv.run_result_id

Line 2999: ,pay_assignment_actions paa

2995: ) IS
2996: SELECT rrv3.result_value UNIT_PRICE , sum(rrv1.result_value) UNIT, sum(rrv2.result_value) AMOUNT
2997: FROM pay_run_result_values rrv1
2998: ,pay_run_results rr1
2999: ,pay_assignment_actions paa
3000: ,pay_payroll_actions ppa
3001: ,pay_run_result_values rrv2
3002: ,pay_run_results rr2
3003: ,pay_run_result_values rrv3

Line 3031: ,pay_assignment_actions paa

3027: ) IS
3028: SELECT rrv3.result_value UNIT_PRICE , rrv1.result_value UNIT, rrv2.result_value AMOUNT
3029: FROM pay_run_result_values rrv1
3030: ,pay_run_results rr1
3031: ,pay_assignment_actions paa
3032: ,pay_payroll_actions ppa
3033: ,pay_run_result_values rrv2
3034: ,pay_run_results rr2
3035: ,pay_run_result_values rrv3

Line 3758: FROM pay_assignment_actions

3754: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
3755: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
3756: AND paaf.assignment_id IN
3757: (SELECT DISTINCT assignment_id
3758: FROM pay_assignment_actions
3759: WHERE payroll_action_id= p_payroll_action_id );
3760:
3761:
3762: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS