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_MX_PTU_CALC dependencies on PAY_MX_YREND_ARCH

Line 303: pay_mx_yrend_arch.load_gre (ln_business_group_id,

299:
300: ld_end_date := add_months(ld_start_date, 12) - 1;
301:
302: ln_step := 2;
303: pay_mx_yrend_arch.load_gre (ln_business_group_id,
304: ln_legal_employer_id,
305: ld_end_date);
306:
307: ln_step := 3;

Line 327: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1

323: AND paa.source_action_id IS NULL
324: AND paf.assignment_id = paa.assignment_id
325: AND ppa.effective_date BETWEEN paf.effective_start_date
326: AND paf.effective_end_date
327: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
328: AND :payroll_action_id > 0
329: ORDER BY paf.person_id';
330: ELSE
331: lv_sql_string :=

Line 347: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1

343: AND paa.source_action_id IS NULL
344: AND paf.assignment_id = paa.assignment_id
345: AND ppa.effective_date BETWEEN paf.effective_start_date
346: AND paf.effective_end_date
347: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
348: AND (NOT EXISTS
349: (SELECT ''x''
350: FROM hr_assignment_set_amendments hasa
351: WHERE hasa.assignment_set_id = ' || ln_asg_set_id || '

Line 463: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1

459: pay_payroll_actions ppa,
460: pay_population_ranges ppr
461: WHERE ppa.business_group_id = cp_bg_id
462: AND paf.assignment_id = paa.assignment_id
463: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1
464: AND ppr.payroll_action_id = p_payroll_action_id
465: AND ppr.chunk_number = p_chunk
466: AND ppr.person_id = paf.person_id
467: AND paf.person_id = paf_pri.person_id

Line 513: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1

509: AND ppa.effective_date BETWEEN paf.effective_start_date
510: AND paf.effective_end_date
511: AND paf_pri.effective_start_date <= cp_end_date
512: AND paf_pri.effective_end_date >= cp_start_date
513: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1
514: AND paf.person_id BETWEEN p_start_person_id
515: AND p_end_person_id
516: AND (paf.employment_category NOT IN ('MX2_TEMP_WRK',
517: 'MX3_TEMP_CONSTRCT_WRK')

Line 705: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN

701:
702: hr_utility.set_location(gv_package || lv_procedure_name, 40);
703:
704: ln_step := 3;
705: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
706:
707: hr_utility.set_location(gv_package || lv_procedure_name, 50);
708:
709: --------------------------------------------------------------

Line 712: pay_mx_yrend_arch.load_gre (ln_business_group_id,

708:
709: --------------------------------------------------------------
710: -- Load the cache with the GREs under the given Legal Employer
711: --------------------------------------------------------------
712: pay_mx_yrend_arch.load_gre (ln_business_group_id,
713: ln_legal_employer_id,
714: ld_end_date);
715: END IF;
716:

Line 765: -- pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

761: ,p_report_qualifier => 'MX'
762: ,p_report_category => 'ARCHIVE');
763:
764: -- FOR cntr_gre IN
765: -- pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
766: -- LOOP
767:
768: IF lb_range_person THEN
769: hr_utility.set_location(gv_package || lv_procedure_name, 60);

Line 826: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

822: -- Check if worked days exceed the minimum limit.
823: --------------------------------------------------------
824: /* bug 8437173 area 1*/
825: FOR cntr_gre IN
826: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
827: LOOP
828: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
829: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(
830: g_worked_days_def_bal_id,

Line 828: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));

824: /* bug 8437173 area 1*/
825: FOR cntr_gre IN
826: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
827: LOOP
828: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
829: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(
830: g_worked_days_def_bal_id,
831: ln_ytd_aaid), 0);
832: END LOOP;

Line 866: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

862: lv_procedure_name, 999);
863:
864: /* bug 8437173 area 2*/
865: FOR cntr_gre IN
866: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
867: LOOP
868: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
869:
870: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(

Line 868: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));

864: /* bug 8437173 area 2*/
865: FOR cntr_gre IN
866: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
867: LOOP
868: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
869:
870: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(
871: g_worked_days_def_bal_id,
872: ln_ytd_aaid), 0);

Line 884: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

880: /* ln_factor_B := ln_factor_B; */
881:
882: /* bug 8437173 area 3*/
883: FOR cntr_gre IN
884: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
885: LOOP
886: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
887:
888: ln_factor_C :=ln_factor_C + NVL(pay_balance_pkg.get_value(

Line 886: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));

882: /* bug 8437173 area 3*/
883: FOR cntr_gre IN
884: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
885: LOOP
886: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
887:
888: ln_factor_C :=ln_factor_C + NVL(pay_balance_pkg.get_value(
889: g_elig_comp_def_bal_id,
890: ln_ytd_aaid), 0);

Line 1274: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN

1270: ,ln_business_group_id);
1271: FETCH c_get_batch_id into g_batch_id;
1272: CLOSE c_get_batch_id;
1273:
1274: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
1275:
1276: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1277:
1278: --------------------------------------------------------------

Line 1281: pay_mx_yrend_arch.load_gre (ln_business_group_id,

1277:
1278: --------------------------------------------------------------
1279: -- Load the cache with the GREs under the given Legal Employer
1280: --------------------------------------------------------------
1281: pay_mx_yrend_arch.load_gre (ln_business_group_id,
1282: ln_legal_employer_id,
1283: ld_end_date);
1284: END IF;
1285: /*bug 8437173 area 4 */

Line 1600: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

1596: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1597:
1598: /*bug 8437173 area 5*/
1599: FOR cntr_gre IN
1600: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
1601: LOOP
1602: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
1603:
1604: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(

Line 1602: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));

1598: /*bug 8437173 area 5*/
1599: FOR cntr_gre IN
1600: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
1601: LOOP
1602: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
1603:
1604: ln_factor_B := ln_factor_B + NVL(pay_balance_pkg.get_value(
1605: g_worked_days_def_bal_id,
1606: ln_ytd_asg_act_id), 0);

Line 1617: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()

1613:
1614: ln_step := 2;
1615: /*bug 8437173 area 6*/
1616: FOR cntr_gre IN
1617: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
1618: LOOP
1619: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
1620:
1621: ln_factor_C := ln_factor_C + NVL(pay_balance_pkg.get_value(

Line 1619: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));

1615: /*bug 8437173 area 6*/
1616: FOR cntr_gre IN
1617: pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
1618: LOOP
1619: pay_balance_pkg.set_context('TAX_UNIT_ID', pay_mx_yrend_arch.g_gre_tab(cntr_gre));
1620:
1621: ln_factor_C := ln_factor_C + NVL(pay_balance_pkg.get_value(
1622: g_elig_comp_def_bal_id,
1623: ln_ytd_asg_act_id), 0);