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

Line 443: pay_assignment_actions act,

439: act1.assignment_action_id prepaid_action_id
440: FROM pay_payroll_actions ppa,
441: pay_payroll_actions appa,
442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,
445: pay_action_interlocks pai,
446: per_all_assignments_f as1
447: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 444: pay_assignment_actions act1,

440: FROM pay_payroll_actions ppa,
441: pay_payroll_actions appa,
442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,
445: pay_action_interlocks pai,
446: per_all_assignments_f as1
447: WHERE ppa.payroll_action_id = p_payroll_action_id
448: AND appa.consolidation_set_id = p_consolidation_id

Line 472: pay_assignment_actions act2,

468: -- Prepayments or Quickpay Prepayments
469: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
470: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
471: FROM pay_action_interlocks pai1,
472: pay_assignment_actions act2,
473: pay_payroll_actions appa3
474: WHERE pai1.locked_action_id = act.assignment_action_id
475: AND act2.assignment_action_id= pai1.locking_action_id
476: AND act2.payroll_action_id = appa3.payroll_action_id

Line 482: pay_assignment_actions act2,

478: AND appa3.action_status = 'C'
479: AND appa3.report_type = 'AE_ARCHIVE')
480: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
481: FROM pay_action_interlocks pai1,
482: pay_assignment_actions act2,
483: pay_payroll_actions appa3
484: WHERE pai1.locked_action_id = act.assignment_action_id
485: AND act2.assignment_action_id= pai1.locking_action_id
486: AND act2.payroll_action_id = appa3.payroll_action_id

Line 545: SELECT pay_assignment_actions_s.NEXTVAL

541: ,l_canonical_start_date
542: ,l_canonical_end_date) LOOP
543:
544: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
545: SELECT pay_assignment_actions_s.NEXTVAL
546: INTO l_actid
547: FROM dual;
548: --
549: g_index_assact := g_index_assact + 1;

Line 592: ,pay_assignment_actions prepay_assact

588: CURSOR csr_prepay_id IS
589: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
590: ,run_payact.date_earned date_earned
591: FROM pay_action_interlocks archive_intlck
592: ,pay_assignment_actions prepay_assact
593: ,pay_payroll_actions prepay_payact
594: ,pay_action_interlocks prepay_intlck
595: ,pay_assignment_actions run_assact
596: ,pay_payroll_actions run_payact

Line 595: ,pay_assignment_actions run_assact

591: FROM pay_action_interlocks archive_intlck
592: ,pay_assignment_actions prepay_assact
593: ,pay_payroll_actions prepay_payact
594: ,pay_action_interlocks prepay_intlck
595: ,pay_assignment_actions run_assact
596: ,pay_payroll_actions run_payact
597: ,pay_assignment_actions archive_assact
598: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
599: and archive_assact.payroll_action_id = p_payroll_action_id

Line 597: ,pay_assignment_actions archive_assact

593: ,pay_payroll_actions prepay_payact
594: ,pay_action_interlocks prepay_intlck
595: ,pay_assignment_actions run_assact
596: ,pay_payroll_actions run_payact
597: ,pay_assignment_actions archive_assact
598: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
599: and archive_assact.payroll_action_id = p_payroll_action_id
600: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
601: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 615: ,pay_assignment_actions prepay_assact

611: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
612: ,run_payact.date_earned date_earned
613: ,run_payact.payroll_action_id run_payact_id
614: FROM pay_action_interlocks archive_intlck
615: ,pay_assignment_actions prepay_assact
616: ,pay_payroll_actions prepay_payact
617: ,pay_action_interlocks prepay_intlck
618: ,pay_assignment_actions run_assact
619: ,pay_payroll_actions run_payact

Line 618: ,pay_assignment_actions run_assact

614: FROM pay_action_interlocks archive_intlck
615: ,pay_assignment_actions prepay_assact
616: ,pay_payroll_actions prepay_payact
617: ,pay_action_interlocks prepay_intlck
618: ,pay_assignment_actions run_assact
619: ,pay_payroll_actions run_payact
620: ,pay_assignment_actions archive_assact
621: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
622: and archive_assact.payroll_action_id = p_payroll_action_id

Line 620: ,pay_assignment_actions archive_assact

616: ,pay_payroll_actions prepay_payact
617: ,pay_action_interlocks prepay_intlck
618: ,pay_assignment_actions run_assact
619: ,pay_payroll_actions run_payact
620: ,pay_assignment_actions archive_assact
621: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
622: and archive_assact.payroll_action_id = p_payroll_action_id
623: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
624: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1539: ,pay_assignment_actions paa

1535: SELECT rrv.result_value
1536: ,rr.run_result_id /*Added for loan*/
1537: FROM pay_run_result_values rrv
1538: ,pay_run_results rr
1539: ,pay_assignment_actions paa
1540: ,pay_payroll_actions ppa
1541: WHERE rrv.input_value_id = p_iv_id
1542: AND rr.element_type_id = p_ele_type_id
1543: AND rr.run_result_id = rrv.run_result_id

Line 1783: pay_assignment_actions paa,

1779: pop.org_payment_method_name,
1780: ppttl.payment_type_name pay_type,
1781: ppp.value value
1782: FROM pay_org_payment_methods_f pop,
1783: pay_assignment_actions paa,
1784: pay_payment_types ppt,
1785: pay_payment_types_tl ppttl,
1786: pay_pre_payments ppp
1787: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1812: pay_assignment_actions paa,

1808: ppp.value value
1809: FROM pay_external_accounts pea,
1810: pay_org_payment_methods_f pop,
1811: pay_personal_payment_methods_f ppm,
1812: pay_assignment_actions paa,
1813: pay_payment_types ppt,
1814: pay_payment_types_tl ppttl,
1815: pay_pre_payments ppp
1816: WHERE pea.id_flex_num=p_flex_num

Line 2037: ,pay_assignment_actions paa

2033: ,p_assignment_action_id NUMBER) IS
2034: SELECT rrv.result_value
2035: FROM pay_run_result_values rrv
2036: ,pay_run_results rr
2037: ,pay_assignment_actions paa
2038: ,pay_payroll_actions ppa
2039: WHERE rrv.input_value_id = p_iv_id
2040: AND rr.element_type_id = p_ele_type_id
2041: AND rr.run_result_id = rrv.run_result_id

Line 2187: FROM pay_assignment_actions paa

2183:
2184: /* Cursor to retrieve Tax Unit Id for setting context */
2185: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2186: SELECT paa.tax_unit_id
2187: FROM pay_assignment_actions paa
2188: WHERE paa.assignment_action_id = p_run_assact_id;
2189:
2190: /* Cursor to fetch defined balance id */
2191: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 2323: ,pay_assignment_actions prepay_assact

2319: ,run_assact.assignment_action_id run_assact_id
2320: ,run_payact.payroll_action_id run_payact_id
2321: ,run_payact.payroll_id payroll_id
2322: FROM pay_action_interlocks archive_intlck
2323: ,pay_assignment_actions prepay_assact
2324: ,pay_payroll_actions prepay_payact
2325: ,pay_action_interlocks prepay_intlck
2326: ,pay_assignment_actions run_assact
2327: ,pay_payroll_actions run_payact

Line 2326: ,pay_assignment_actions run_assact

2322: FROM pay_action_interlocks archive_intlck
2323: ,pay_assignment_actions prepay_assact
2324: ,pay_payroll_actions prepay_payact
2325: ,pay_action_interlocks prepay_intlck
2326: ,pay_assignment_actions run_assact
2327: ,pay_payroll_actions run_payact
2328: WHERE archive_intlck.locking_action_id = p_locking_action_id
2329: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2330: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2348: ,pay_assignment_actions paa

2344: ppa.effective_date effective_date,
2345: ptp.start_date start_date
2346: FROM per_time_periods ptp
2347: ,pay_payroll_actions ppa
2348: ,pay_assignment_actions paa
2349: WHERE ptp.payroll_id =ppa.payroll_id
2350: AND ppa.payroll_action_id =paa.payroll_action_id
2351: AND paa.assignment_action_id =p_assact_id
2352: AND ppa.payroll_action_id =p_pay_act_id

Line 2359: FROM pay_assignment_actions

2355:
2356: /* Cursor to retrieve Archive Payroll Action Id */
2357: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2358: SELECT payroll_action_id
2359: FROM pay_assignment_actions
2360: WHERE assignment_Action_id = p_assignment_action_id;
2361:
2362:
2363: l_archive_payact_id NUMBER;