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

Line 455: pay_assignment_actions act,

451: act1.assignment_action_id prepaid_action_id
452: FROM pay_payroll_actions ppa,
453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,
457: pay_action_interlocks pai,
458: per_all_assignments_f as1
459: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 456: pay_assignment_actions act1,

452: FROM pay_payroll_actions ppa,
453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,
457: pay_action_interlocks pai,
458: per_all_assignments_f as1
459: WHERE ppa.payroll_action_id = p_payroll_action_id
460: AND appa.consolidation_set_id = p_consolidation_id

Line 479: pay_assignment_actions act2,

475: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
476:
477: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
478: FROM pay_action_interlocks pai1,
479: pay_assignment_actions act2,
480: pay_payroll_actions appa3
481: WHERE pai1.locked_action_id = act.assignment_action_id
482: AND act2.assignment_action_id= pai1.locking_action_id
483: AND act2.payroll_action_id = appa3.payroll_action_id

Line 490: pay_assignment_actions act2,

486: AND appa3.report_type = 'PYDKARCHIVE')
487:
488: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
489: FROM pay_action_interlocks pai1,
490: pay_assignment_actions act2,
491: pay_payroll_actions appa3
492: WHERE pai1.locked_action_id = act.assignment_action_id
493: AND act2.assignment_action_id= pai1.locking_action_id
494: AND act2.payroll_action_id = appa3.payroll_action_id

Line 553: SELECT pay_assignment_actions_s.NEXTVAL

549: ,l_canonical_end_date) LOOP
550:
551: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
552:
553: SELECT pay_assignment_actions_s.NEXTVAL
554: INTO l_actid
555: FROM dual;
556: --
557: g_index_assact := g_index_assact + 1;

Line 597: ,pay_assignment_actions prepay_assact

593: CURSOR csr_prepay_id IS
594: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
595: ,run_payact.date_earned date_earned
596: FROM pay_action_interlocks archive_intlck
597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact

Line 600: ,pay_assignment_actions run_assact

596: FROM pay_action_interlocks archive_intlck
597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact
602: ,pay_assignment_actions archive_assact
603: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
604: and archive_assact.payroll_action_id = p_payroll_action_id

Line 602: ,pay_assignment_actions archive_assact

598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact
602: ,pay_assignment_actions archive_assact
603: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
604: and archive_assact.payroll_action_id = p_payroll_action_id
605: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
606: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 622: ,pay_assignment_actions prepay_assact

618: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
619: ,run_payact.date_earned date_earned
620: ,run_payact.payroll_action_id run_payact_id
621: FROM pay_action_interlocks archive_intlck
622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact

Line 625: ,pay_assignment_actions run_assact

621: FROM pay_action_interlocks archive_intlck
622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact
627: ,pay_assignment_actions archive_assact
628: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
629: and archive_assact.payroll_action_id = p_payroll_action_id

Line 627: ,pay_assignment_actions archive_assact

623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact
627: ,pay_assignment_actions archive_assact
628: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
629: and archive_assact.payroll_action_id = p_payroll_action_id
630: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
631: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1628: pay_assignment_actions paa,

1624: pop.org_payment_method_name opm_name,
1625: ppttl.payment_type_name pay_type,
1626: ppp.value value
1627: FROM pay_org_payment_methods_f pop,
1628: pay_assignment_actions paa,
1629: pay_payment_types ppt,
1630: pay_payment_types_tl ppttl,
1631: pay_pre_payments ppp
1632: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1655: pay_assignment_actions paa,

1651: ppp.value value
1652: FROM pay_external_accounts pea,
1653: pay_org_payment_methods_f pop,
1654: pay_personal_payment_methods_f ppm,
1655: pay_assignment_actions paa,
1656: pay_payment_types ppt,
1657: pay_payment_types_tl ppttl,
1658: pay_pre_payments ppp
1659: WHERE

Line 1859: ,pay_assignment_actions paa

1855: FROM pay_accrual_plans pap
1856: ,pay_element_types_f pet
1857: ,pay_element_links_f pel
1858: ,pay_element_entries_f pee
1859: ,pay_assignment_actions paa
1860: ,pay_payroll_actions ppa
1861: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1862: AND pel.element_type_id = pet.element_type_id
1863: AND pee.element_link_id = pel.element_link_id

Line 2020: ,pay_assignment_actions paa

2016: ,p_assignment_action_id NUMBER) IS
2017: SELECT rrv.result_value
2018: FROM pay_run_result_values rrv
2019: ,pay_run_results rr
2020: ,pay_assignment_actions paa
2021: ,pay_payroll_actions ppa
2022: WHERE rrv.input_value_id = p_iv_id
2023: AND rr.element_type_id = p_ele_type_id
2024: AND rr.run_result_id = rrv.run_result_id

Line 2169: FROM pay_assignment_actions paa

2165: -----------------
2166: /* Cursor to retrieve Tax Unit Id for setting context */
2167: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2168: SELECT paa.tax_unit_id
2169: FROM pay_assignment_actions paa
2170: WHERE paa.assignment_action_id = p_run_assact_id;
2171: -----------------
2172: /* Cursor to fetch defined balance id */
2173: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 2398: ,pay_assignment_actions prepay_assact

2394: ,run_assact.assignment_action_id run_assact_id
2395: ,run_payact.payroll_action_id run_payact_id
2396: ,run_payact.payroll_id payroll_id
2397: FROM pay_action_interlocks archive_intlck
2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact
2402: ,pay_payroll_actions run_payact

Line 2401: ,pay_assignment_actions run_assact

2397: FROM pay_action_interlocks archive_intlck
2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact
2402: ,pay_payroll_actions run_payact
2403: WHERE archive_intlck.locking_action_id = p_locking_action_id
2404: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2405: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2423: ,pay_assignment_actions paa

2419: ppa.effective_date effective_date,
2420: ptp.start_date start_date
2421: FROM per_time_periods ptp
2422: ,pay_payroll_actions ppa
2423: ,pay_assignment_actions paa
2424: WHERE ptp.payroll_id =ppa.payroll_id
2425: AND ppa.payroll_action_id =paa.payroll_action_id
2426: AND paa.assignment_action_id =p_assact_id
2427: AND ppa.payroll_action_id =p_pay_act_id

Line 2433: FROM pay_assignment_actions

2429: -----------------
2430: /* Cursor to retrieve Archive Payroll Action Id */
2431: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2432: SELECT payroll_action_id
2433: FROM pay_assignment_actions
2434: WHERE assignment_Action_id = p_assignment_action_id;
2435: -----------------
2436: l_archive_payact_id NUMBER;
2437: l_record_count NUMBER;

Line 3239: ,pay_assignment_actions paa

3235: /* Added for Pension changes */
3236: , rr.run_result_id
3237: FROM pay_run_result_values rrv
3238: ,pay_run_results rr
3239: ,pay_assignment_actions paa
3240: ,pay_payroll_actions ppa
3241: WHERE rrv.input_value_id = p_iv_id
3242: AND rr.element_type_id = p_ele_type_id
3243: AND rr.run_result_id = rrv.run_result_id