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

Line 441: pay_assignment_actions act,

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

Line 442: pay_assignment_actions act1,

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

Line 470: pay_assignment_actions act2,

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

Line 480: pay_assignment_actions act2,

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

Line 543: SELECT pay_assignment_actions_s.NEXTVAL

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

Line 590: ,pay_assignment_actions prepay_assact

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

Line 593: ,pay_assignment_actions run_assact

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

Line 595: ,pay_assignment_actions archive_assact

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

Line 613: ,pay_assignment_actions prepay_assact

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

Line 616: ,pay_assignment_actions run_assact

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

Line 618: ,pay_assignment_actions archive_assact

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

Line 1522: pay_assignment_actions paa,

1518: pop.org_payment_method_name,
1519: ppttl.payment_type_name pay_type,
1520: ppp.value value
1521: FROM pay_org_payment_methods_f pop,
1522: pay_assignment_actions paa,
1523: pay_payment_types ppt,
1524: pay_payment_types_tl ppttl,
1525: pay_pre_payments ppp
1526: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1551: pay_assignment_actions paa,

1547: ppp.value value
1548: FROM pay_external_accounts pea,
1549: pay_org_payment_methods_f pop,
1550: pay_personal_payment_methods_f ppm,
1551: pay_assignment_actions paa,
1552: pay_payment_types ppt,
1553: pay_payment_types_tl ppttl,
1554: pay_pre_payments ppp
1555: WHERE pea.id_flex_num=p_flex_num

Line 1773: ,pay_assignment_actions paa

1769: ,p_assignment_action_id NUMBER) IS
1770: SELECT rrv.result_value
1771: FROM pay_run_result_values rrv
1772: ,pay_run_results rr
1773: ,pay_assignment_actions paa
1774: ,pay_payroll_actions ppa
1775: WHERE rrv.input_value_id = p_iv_id
1776: AND rr.element_type_id = p_ele_type_id
1777: AND rr.run_result_id = rrv.run_result_id

Line 1924: FROM pay_assignment_actions paa

1920:
1921: /* Cursor to retrieve Tax Unit Id for setting context */
1922: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
1923: SELECT paa.tax_unit_id
1924: FROM pay_assignment_actions paa
1925: WHERE paa.assignment_action_id = p_run_assact_id;
1926:
1927: /* Cursor to fetch defined balance id */
1928: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 2060: ,pay_assignment_actions prepay_assact

2056: ,run_assact.assignment_action_id run_assact_id
2057: ,run_payact.payroll_action_id run_payact_id
2058: ,run_payact.payroll_id payroll_id
2059: FROM pay_action_interlocks archive_intlck
2060: ,pay_assignment_actions prepay_assact
2061: ,pay_payroll_actions prepay_payact
2062: ,pay_action_interlocks prepay_intlck
2063: ,pay_assignment_actions run_assact
2064: ,pay_payroll_actions run_payact

Line 2063: ,pay_assignment_actions run_assact

2059: FROM pay_action_interlocks archive_intlck
2060: ,pay_assignment_actions prepay_assact
2061: ,pay_payroll_actions prepay_payact
2062: ,pay_action_interlocks prepay_intlck
2063: ,pay_assignment_actions run_assact
2064: ,pay_payroll_actions run_payact
2065: WHERE archive_intlck.locking_action_id = p_locking_action_id
2066: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2067: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2085: ,pay_assignment_actions paa

2081: ppa.effective_date effective_date,
2082: ptp.start_date start_date
2083: FROM per_time_periods ptp
2084: ,pay_payroll_actions ppa
2085: ,pay_assignment_actions paa
2086: WHERE ptp.payroll_id =ppa.payroll_id
2087: AND ppa.payroll_action_id =paa.payroll_action_id
2088: AND paa.assignment_action_id =p_assact_id
2089: AND ppa.payroll_action_id =p_pay_act_id

Line 2096: FROM pay_assignment_actions

2092:
2093: /* Cursor to retrieve Archive Payroll Action Id */
2094: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2095: SELECT payroll_action_id
2096: FROM pay_assignment_actions
2097: WHERE assignment_Action_id = p_assignment_action_id;
2098:
2099:
2100: l_archive_payact_id NUMBER;