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

Line 368: pay_assignment_actions act,

364: act1.assignment_action_id prepaid_action_id
365: FROM pay_payroll_actions ppa,
366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,
370: pay_action_interlocks pai,
371: per_all_assignments_f as1
372: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 369: pay_assignment_actions act1,

365: FROM pay_payroll_actions ppa,
366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,
370: pay_action_interlocks pai,
371: per_all_assignments_f as1
372: WHERE ppa.payroll_action_id = p_payroll_action_id
373: AND appa.consolidation_set_id = p_consolidation_id

Line 397: pay_assignment_actions act2,

393: -- Prepayments or Quickpay Prepayments
394: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
395: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
396: FROM pay_action_interlocks pai1,
397: pay_assignment_actions act2,
398: pay_payroll_actions appa3
399: WHERE pai1.locked_action_id = act.assignment_action_id
400: AND act2.assignment_action_id= pai1.locking_action_id
401: AND act2.payroll_action_id = appa3.payroll_action_id

Line 407: pay_assignment_actions act2,

403: AND appa3.action_status = 'C'
404: AND appa3.report_type = 'FI_ARCHIVE')
405: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
406: FROM pay_action_interlocks pai1,
407: pay_assignment_actions act2,
408: pay_payroll_actions appa3
409: WHERE pai1.locked_action_id = act.assignment_action_id
410: AND act2.assignment_action_id= pai1.locking_action_id
411: AND act2.payroll_action_id = appa3.payroll_action_id

Line 457: SELECT pay_assignment_actions_s.NEXTVAL

453: ,l_consolidation_set
454: ,l_canonical_start_date
455: ,l_canonical_end_date) LOOP
456: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
457: SELECT pay_assignment_actions_s.NEXTVAL
458: INTO l_actid
459: FROM dual;
460: --
461: g_index_assact := g_index_assact + 1;

Line 488: ,pay_assignment_actions prepay_assact

484: CURSOR csr_prepay_id IS
485: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
486: ,run_payact.date_earned date_earned
487: FROM pay_action_interlocks archive_intlck
488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact

Line 491: ,pay_assignment_actions run_assact

487: FROM pay_action_interlocks archive_intlck
488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact
493: ,pay_assignment_actions archive_assact
494: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
495: and archive_assact.payroll_action_id = p_payroll_action_id

Line 493: ,pay_assignment_actions archive_assact

489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact
493: ,pay_assignment_actions archive_assact
494: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
495: and archive_assact.payroll_action_id = p_payroll_action_id
496: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
497: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 510: ,pay_assignment_actions prepay_assact

506: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
507: ,run_payact.date_earned date_earned
508: ,run_payact.payroll_action_id run_payact_id
509: FROM pay_action_interlocks archive_intlck
510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact

Line 513: ,pay_assignment_actions run_assact

509: FROM pay_action_interlocks archive_intlck
510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact
515: ,pay_assignment_actions archive_assact
516: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
517: and archive_assact.payroll_action_id = p_payroll_action_id

Line 515: ,pay_assignment_actions archive_assact

511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact
515: ,pay_assignment_actions archive_assact
516: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
517: and archive_assact.payroll_action_id = p_payroll_action_id
518: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
519: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1253: pay_assignment_actions paa,

1249: pop.org_payment_method_name opm_name,
1250: ppttl.payment_type_name pay_type,
1251: ppp.value value
1252: FROM pay_org_payment_methods_f pop,
1253: pay_assignment_actions paa,
1254: pay_payment_types ppt,
1255: pay_payment_types_tl ppttl,
1256: pay_pre_payments ppp
1257: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 1280: pay_assignment_actions paa,

1276: ppp.value value
1277: FROM pay_external_accounts pea,
1278: pay_org_payment_methods_f pop,
1279: pay_personal_payment_methods_f ppm,
1280: pay_assignment_actions paa,
1281: pay_payment_types ppt,
1282: pay_payment_types_tl ppttl,
1283: pay_pre_payments ppp
1284: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)

Line 1457: ,pay_assignment_actions paa

1453: FROM pay_accrual_plans pap
1454: ,pay_element_types_f pet
1455: ,pay_element_links_f pel
1456: ,pay_element_entries_f pee
1457: ,pay_assignment_actions paa
1458: ,pay_payroll_actions ppa
1459: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1460: AND pel.element_type_id = pet.element_type_id
1461: AND pee.element_link_id = pel.element_link_id

Line 1611: ,pay_assignment_actions paa

1607: ,p_assignment_action_id NUMBER) IS
1608: SELECT rrv.result_value
1609: FROM pay_run_result_values rrv
1610: ,pay_run_results rr
1611: ,pay_assignment_actions paa
1612: ,pay_payroll_actions ppa
1613: WHERE rrv.input_value_id = p_iv_id
1614: AND rr.element_type_id = p_ele_type_id
1615: AND rr.run_result_id = rrv.run_result_id

Line 1714: FROM pay_assignment_actions paa

1710: AND org_information1 = 'BALANCE';
1711: /* Cursor to retrieve Tax Unit Id for setting context */
1712: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
1713: SELECT paa.tax_unit_id
1714: FROM pay_assignment_actions paa
1715: WHERE paa.assignment_action_id = p_run_assact_id;
1716: /* Cursor to fetch defined balance id */
1717: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS
1718: SELECT defined_balance_id

Line 2540: ,pay_assignment_actions prepay_assact

2536: ,run_assact.assignment_action_id run_assact_id
2537: ,run_payact.payroll_action_id run_payact_id
2538: ,run_payact.payroll_id payroll_id
2539: FROM pay_action_interlocks archive_intlck
2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact
2544: ,pay_payroll_actions run_payact

Line 2543: ,pay_assignment_actions run_assact

2539: FROM pay_action_interlocks archive_intlck
2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact
2544: ,pay_payroll_actions run_payact
2545: WHERE archive_intlck.locking_action_id = p_locking_action_id
2546: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2547: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2564: ,pay_assignment_actions paa

2560: ppa.effective_date effective_date,
2561: ptp.start_date start_date
2562: FROM per_time_periods ptp
2563: ,pay_payroll_actions ppa
2564: ,pay_assignment_actions paa
2565: WHERE ptp.payroll_id =ppa.payroll_id
2566: AND ppa.payroll_action_id =paa.payroll_action_id
2567: AND paa.assignment_action_id =p_assact_id
2568: AND ppa.payroll_action_id =p_pay_act_id

Line 2574: FROM pay_assignment_actions

2570: AND ptp.end_date;
2571: /* Cursor to retrieve Archive Payroll Action Id */
2572: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
2573: SELECT payroll_action_id
2574: FROM pay_assignment_actions
2575: WHERE assignment_Action_id = p_assignment_action_id;
2576: /* Cursor to retrieve Tax Unit Id for setting context */
2577: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2578: SELECT paa.tax_unit_id

Line 2579: FROM pay_assignment_actions paa

2575: WHERE assignment_Action_id = p_assignment_action_id;
2576: /* Cursor to retrieve Tax Unit Id for setting context */
2577: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
2578: SELECT paa.tax_unit_id
2579: FROM pay_assignment_actions paa
2580: WHERE paa.assignment_action_id = p_run_assact_id;
2581:
2582: l_tu_id NUMBER;
2583: l_archive_payact_id NUMBER;

Line 2786: ,pay_assignment_actions paa

2782: ,p_assignment_action_id NUMBER) IS
2783: SELECT rrv.result_value
2784: FROM pay_run_result_values rrv
2785: ,pay_run_results rr
2786: ,pay_assignment_actions paa
2787: ,pay_payroll_actions ppa
2788: WHERE rrv.input_value_id = p_iv_id
2789: AND rr.element_type_id = p_ele_type_id
2790: AND rr.run_result_id = rrv.run_result_id

Line 2912: FROM pay_assignment_actions

2908: WHERE p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
2909: AND paaf.SOFT_CODING_KEYFLEX_ID = hsck.SOFT_CODING_KEYFLEX_ID
2910: AND paaf.assignment_id IN
2911: (SELECT DISTINCT assignment_id
2912: FROM pay_assignment_actions
2913: WHERE payroll_action_id= p_payroll_action_id );
2914:
2915:
2916: CURSOR csr_legal_emp(p_organization_id NUMBER , p_business_group_id NUMBER ) IS