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

Line 434: pay_assignment_actions act,

430: act1.assignment_action_id prepaid_action_id
431: FROM pay_payroll_actions ppa,
432: pay_payroll_actions appa,
433: pay_payroll_actions appa2,
434: pay_assignment_actions act,
435: pay_assignment_actions act1,
436: pay_action_interlocks pai,
437: per_all_assignments_f as1
438: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 435: pay_assignment_actions act1,

431: FROM pay_payroll_actions ppa,
432: pay_payroll_actions appa,
433: pay_payroll_actions appa2,
434: pay_assignment_actions act,
435: pay_assignment_actions act1,
436: pay_action_interlocks pai,
437: per_all_assignments_f as1
438: WHERE ppa.payroll_action_id = p_payroll_action_id
439: AND appa.consolidation_set_id = p_consolidation_id

Line 463: pay_assignment_actions act2,

459: -- Prepayments or Quickpay Prepayments
460: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
461: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
462: FROM pay_action_interlocks pai1,
463: pay_assignment_actions act2,
464: pay_payroll_actions appa3
465: WHERE pai1.locked_action_id = act.assignment_action_id
466: AND act2.assignment_action_id= pai1.locking_action_id
467: AND act2.payroll_action_id = appa3.payroll_action_id

Line 473: pay_assignment_actions act2,

469: AND appa3.action_status = 'C'
470: AND appa3.report_type = 'SA_ARCHIVE')
471: AND NOT EXISTS ( SELECT /*+ ORDERED */ NULL
472: FROM pay_action_interlocks pai1,
473: pay_assignment_actions act2,
474: pay_payroll_actions appa3
475: WHERE pai1.locked_action_id = act.assignment_action_id
476: AND act2.assignment_action_id= pai1.locking_action_id
477: AND act2.payroll_action_id = appa3.payroll_action_id

Line 536: SELECT pay_assignment_actions_s.NEXTVAL

532: ,l_canonical_start_date
533: ,l_canonical_end_date) LOOP
534:
535: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
536: SELECT pay_assignment_actions_s.NEXTVAL
537: INTO l_actid
538: FROM dual;
539: --
540: g_index_assact := g_index_assact + 1;

Line 583: ,pay_assignment_actions prepay_assact

579: CURSOR csr_prepay_id IS
580: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
581: ,run_payact.date_earned date_earned
582: FROM pay_action_interlocks archive_intlck
583: ,pay_assignment_actions prepay_assact
584: ,pay_payroll_actions prepay_payact
585: ,pay_action_interlocks prepay_intlck
586: ,pay_assignment_actions run_assact
587: ,pay_payroll_actions run_payact

Line 586: ,pay_assignment_actions run_assact

582: FROM pay_action_interlocks archive_intlck
583: ,pay_assignment_actions prepay_assact
584: ,pay_payroll_actions prepay_payact
585: ,pay_action_interlocks prepay_intlck
586: ,pay_assignment_actions run_assact
587: ,pay_payroll_actions run_payact
588: ,pay_assignment_actions archive_assact
589: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
590: and archive_assact.payroll_action_id = p_payroll_action_id

Line 588: ,pay_assignment_actions archive_assact

584: ,pay_payroll_actions prepay_payact
585: ,pay_action_interlocks prepay_intlck
586: ,pay_assignment_actions run_assact
587: ,pay_payroll_actions run_payact
588: ,pay_assignment_actions archive_assact
589: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
590: and archive_assact.payroll_action_id = p_payroll_action_id
591: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
592: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 606: ,pay_assignment_actions prepay_assact

602: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
603: ,run_payact.date_earned date_earned
604: ,run_payact.payroll_action_id run_payact_id
605: FROM pay_action_interlocks archive_intlck
606: ,pay_assignment_actions prepay_assact
607: ,pay_payroll_actions prepay_payact
608: ,pay_action_interlocks prepay_intlck
609: ,pay_assignment_actions run_assact
610: ,pay_payroll_actions run_payact

Line 609: ,pay_assignment_actions run_assact

605: FROM pay_action_interlocks archive_intlck
606: ,pay_assignment_actions prepay_assact
607: ,pay_payroll_actions prepay_payact
608: ,pay_action_interlocks prepay_intlck
609: ,pay_assignment_actions run_assact
610: ,pay_payroll_actions run_payact
611: ,pay_assignment_actions archive_assact
612: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
613: and archive_assact.payroll_action_id = p_payroll_action_id

Line 611: ,pay_assignment_actions archive_assact

607: ,pay_payroll_actions prepay_payact
608: ,pay_action_interlocks prepay_intlck
609: ,pay_assignment_actions run_assact
610: ,pay_payroll_actions run_payact
611: ,pay_assignment_actions archive_assact
612: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
613: and archive_assact.payroll_action_id = p_payroll_action_id
614: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
615: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1548: pay_assignment_actions paa,

1544: pop.org_payment_method_name,
1545: ppttl.payment_type_name pay_type,
1546: ppp.value value
1547: FROM pay_org_payment_methods_f pop,
1548: pay_assignment_actions paa,
1549: pay_payment_types ppt,
1550: pay_payment_types_tl ppttl,
1551: pay_pre_payments ppp
1552: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1576: pay_assignment_actions paa,

1572: ppp.value value
1573: FROM pay_external_accounts pea,
1574: pay_org_payment_methods_f pop,
1575: pay_personal_payment_methods_f ppm,
1576: pay_assignment_actions paa,
1577: pay_payment_types ppt,
1578: pay_payment_types_tl ppttl,
1579: pay_pre_payments ppp
1580: WHERE pea.id_flex_num=20

Line 1780: ,pay_assignment_actions paa

1776: FROM pay_accrual_plans pap
1777: ,pay_element_types_f pet
1778: ,pay_element_links_f pel
1779: ,pay_element_entries_f pee
1780: ,pay_assignment_actions paa
1781: ,pay_payroll_actions ppa
1782: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1783: AND pel.element_type_id = pet.element_type_id
1784: AND pee.element_link_id = pel.element_link_id

Line 1949: ,pay_assignment_actions paa

1945: ,p_assignment_action_id NUMBER) IS
1946: SELECT rrv.result_value
1947: FROM pay_run_result_values rrv
1948: ,pay_run_results rr
1949: ,pay_assignment_actions paa
1950: ,pay_payroll_actions ppa
1951: WHERE rrv.input_value_id = p_iv_id
1952: AND rr.element_type_id = p_ele_type_id
1953: AND rr.run_result_id = rrv.run_result_id

Line 2101: FROM pay_assignment_actions paa

2097:
2098: /* Cursor to retrieve Tax Unit Id for setting context */
2099: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2100: SELECT paa.tax_unit_id
2101: FROM pay_assignment_actions paa
2102: WHERE paa.assignment_action_id = p_run_assact_id;
2103:
2104: /* Cursor to fetch defined balance id */
2105: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 2226: ,pay_assignment_actions prepay_assact

2222: ,run_assact.assignment_action_id run_assact_id
2223: ,run_payact.payroll_action_id run_payact_id
2224: ,run_payact.payroll_id payroll_id
2225: FROM pay_action_interlocks archive_intlck
2226: ,pay_assignment_actions prepay_assact
2227: ,pay_payroll_actions prepay_payact
2228: ,pay_action_interlocks prepay_intlck
2229: ,pay_assignment_actions run_assact
2230: ,pay_payroll_actions run_payact

Line 2229: ,pay_assignment_actions run_assact

2225: FROM pay_action_interlocks archive_intlck
2226: ,pay_assignment_actions prepay_assact
2227: ,pay_payroll_actions prepay_payact
2228: ,pay_action_interlocks prepay_intlck
2229: ,pay_assignment_actions run_assact
2230: ,pay_payroll_actions run_payact
2231: WHERE archive_intlck.locking_action_id = p_locking_action_id
2232: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2233: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2251: ,pay_assignment_actions paa

2247: ppa.effective_date effective_date,
2248: ptp.start_date start_date
2249: FROM per_time_periods ptp
2250: ,pay_payroll_actions ppa
2251: ,pay_assignment_actions paa
2252: WHERE ptp.payroll_id =ppa.payroll_id
2253: AND ppa.payroll_action_id =paa.payroll_action_id
2254: AND paa.assignment_action_id =p_assact_id
2255: AND ppa.payroll_action_id =p_pay_act_id

Line 2262: FROM pay_assignment_actions

2258:
2259: /* Cursor to retrieve Archive Payroll Action Id */
2260: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2261: SELECT payroll_action_id
2262: FROM pay_assignment_actions
2263: WHERE assignment_Action_id = p_assignment_action_id;
2264:
2265:
2266: l_archive_payact_id NUMBER;