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 435: pay_assignment_actions act,

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

Line 436: pay_assignment_actions act1,

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

Line 464: pay_assignment_actions act2,

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

Line 474: pay_assignment_actions act2,

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

Line 537: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 584: ,pay_assignment_actions prepay_assact

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

Line 587: ,pay_assignment_actions run_assact

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

Line 589: ,pay_assignment_actions archive_assact

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

Line 607: ,pay_assignment_actions prepay_assact

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

Line 610: ,pay_assignment_actions run_assact

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

Line 612: ,pay_assignment_actions archive_assact

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

Line 1511: ,pay_assignment_actions paa

1507: CURSOR csr_result_value(p_run_assact_id NUMBER,p_payroll_action_id NUMBER) IS
1508: SELECT rrv.result_value , pai.action_information2, pai.action_information3,pai.action_information5
1509: FROM pay_run_result_values rrv
1510: ,pay_run_results rr
1511: ,pay_assignment_actions paa
1512: ,pay_payroll_actions ppa
1513: ,pay_action_information pai
1514: WHERE rrv.input_value_id = pai.action_information3
1515: AND rr.element_type_id = pai.action_information2

Line 1656: pay_assignment_actions paa,

1652: pop.org_payment_method_name,
1653: ppttl.payment_type_name pay_type,
1654: ppp.value value
1655: FROM pay_org_payment_methods_f pop,
1656: pay_assignment_actions paa,
1657: pay_payment_types ppt,
1658: pay_payment_types_tl ppttl,
1659: pay_pre_payments ppp
1660: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1684: pay_assignment_actions paa,

1680: ppp.value value
1681: FROM pay_external_accounts pea,
1682: pay_org_payment_methods_f pop,
1683: pay_personal_payment_methods_f ppm,
1684: pay_assignment_actions paa,
1685: pay_payment_types ppt,
1686: pay_payment_types_tl ppttl,
1687: pay_pre_payments ppp
1688: WHERE pea.id_flex_num=20

Line 1888: ,pay_assignment_actions paa

1884: FROM pay_accrual_plans pap
1885: ,pay_element_types_f pet
1886: ,pay_element_links_f pel
1887: ,pay_element_entries_f pee
1888: ,pay_assignment_actions paa
1889: ,pay_payroll_actions ppa
1890: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1891: AND pel.element_type_id = pet.element_type_id
1892: AND pee.element_link_id = pel.element_link_id

Line 2057: ,pay_assignment_actions paa

2053: ,p_assignment_action_id NUMBER) IS
2054: SELECT rrv.result_value
2055: FROM pay_run_result_values rrv
2056: ,pay_run_results rr
2057: ,pay_assignment_actions paa
2058: ,pay_payroll_actions ppa
2059: WHERE rrv.input_value_id = p_iv_id
2060: AND rr.element_type_id = p_ele_type_id
2061: AND rr.run_result_id = rrv.run_result_id

Line 2209: FROM pay_assignment_actions paa

2205:
2206: /* Cursor to retrieve Tax Unit Id for setting context */
2207: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2208: SELECT paa.tax_unit_id
2209: FROM pay_assignment_actions paa
2210: WHERE paa.assignment_action_id = p_run_assact_id;
2211:
2212: /* Cursor to fetch defined balance id */
2213: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 2334: ,pay_assignment_actions prepay_assact

2330: ,run_assact.assignment_action_id run_assact_id
2331: ,run_payact.payroll_action_id run_payact_id
2332: ,run_payact.payroll_id payroll_id
2333: FROM pay_action_interlocks archive_intlck
2334: ,pay_assignment_actions prepay_assact
2335: ,pay_payroll_actions prepay_payact
2336: ,pay_action_interlocks prepay_intlck
2337: ,pay_assignment_actions run_assact
2338: ,pay_payroll_actions run_payact

Line 2337: ,pay_assignment_actions run_assact

2333: FROM pay_action_interlocks archive_intlck
2334: ,pay_assignment_actions prepay_assact
2335: ,pay_payroll_actions prepay_payact
2336: ,pay_action_interlocks prepay_intlck
2337: ,pay_assignment_actions run_assact
2338: ,pay_payroll_actions run_payact
2339: WHERE archive_intlck.locking_action_id = p_locking_action_id
2340: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2341: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2359: ,pay_assignment_actions paa

2355: ppa.effective_date effective_date,
2356: ptp.start_date start_date
2357: FROM per_time_periods ptp
2358: ,pay_payroll_actions ppa
2359: ,pay_assignment_actions paa
2360: WHERE ptp.payroll_id =ppa.payroll_id
2361: AND ppa.payroll_action_id =paa.payroll_action_id
2362: AND paa.assignment_action_id =p_assact_id
2363: AND ppa.payroll_action_id =p_pay_act_id

Line 2370: FROM pay_assignment_actions

2366:
2367: /* Cursor to retrieve Archive Payroll Action Id */
2368: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2369: SELECT payroll_action_id
2370: FROM pay_assignment_actions
2371: WHERE assignment_Action_id = p_assignment_action_id;
2372:
2373:
2374: l_archive_payact_id NUMBER;