APPS.PAY_MX_PTU_CALC dependencies on PAY_MX_YREND_ARCH

Line 297: pay_mx_yrend_arch.load_gre (ln_business_group_id,

293:
294: ld_end_date := add_months(ld_start_date, 12) - 1;
295:
296: ln_step := 2;
297: pay_mx_yrend_arch.load_gre (ln_business_group_id,
298: ln_legal_employer_id,
299: ld_end_date);
300:
301: ln_step := 3;

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

317: AND paa.source_action_id IS NULL
318: AND paf.assignment_id = paa.assignment_id
319: AND ppa.effective_date BETWEEN paf.effective_start_date
320: AND paf.effective_end_date
321: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
322: AND :payroll_action_id > 0
323: ORDER BY paf.person_id';
324: ELSE
325: lv_sql_string :=

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

337: AND paa.source_action_id IS NULL
338: AND paf.assignment_id = paa.assignment_id
339: AND ppa.effective_date BETWEEN paf.effective_start_date
340: AND paf.effective_end_date
341: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
342: AND (NOT EXISTS
343: (SELECT ''x''
344: FROM hr_assignment_set_amendments hasa
345: WHERE hasa.assignment_set_id = ' || ln_asg_set_id || '

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

453: pay_payroll_actions ppa,
454: pay_population_ranges ppr
455: WHERE ppa.business_group_id = cp_bg_id
456: AND paf.assignment_id = paa.assignment_id
457: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1
458: AND ppr.payroll_action_id = p_payroll_action_id
459: AND ppr.chunk_number = p_chunk
460: AND ppr.person_id = paf.person_id
461: AND paf.person_id = paf_pri.person_id

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

501: AND ppa.effective_date BETWEEN paf.effective_start_date
502: AND paf.effective_end_date
503: AND paf_pri.effective_start_date <= cp_end_date
504: AND paf_pri.effective_end_date >= cp_start_date
505: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1
506: AND paf.person_id BETWEEN p_start_person_id
507: AND p_end_person_id
508: AND (paf.employment_category NOT IN ('MX2_TEMP_WRK',
509: 'MX3_TEMP_CONSTRCT_WRK')

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

691:
692: hr_utility.set_location(gv_package || lv_procedure_name, 40);
693:
694: ln_step := 3;
695: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
696:
697: hr_utility.set_location(gv_package || lv_procedure_name, 50);
698:
699: --------------------------------------------------------------

Line 702: pay_mx_yrend_arch.load_gre (ln_business_group_id,

698:
699: --------------------------------------------------------------
700: -- Load the cache with the GREs under the given Legal Employer
701: --------------------------------------------------------------
702: pay_mx_yrend_arch.load_gre (ln_business_group_id,
703: ln_legal_employer_id,
704: ld_end_date);
705: END IF;
706:

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

751: ,p_report_qualifier => 'MX'
752: ,p_report_category => 'ARCHIVE');
753:
754: -- FOR cntr_gre IN
755: -- pay_mx_yrend_arch.g_gre_tab.first()..pay_mx_yrend_arch.g_gre_tab.last()
756: -- LOOP
757:
758: IF lb_range_person THEN
759: hr_utility.set_location(gv_package || lv_procedure_name, 60);

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

1233: ,ln_business_group_id);
1234: FETCH c_get_batch_id into g_batch_id;
1235: CLOSE c_get_batch_id;
1236:
1237: IF pay_mx_yrend_arch.g_gre_tab.count() = 0 THEN
1238:
1239: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1240:
1241: --------------------------------------------------------------

Line 1244: pay_mx_yrend_arch.load_gre (ln_business_group_id,

1240:
1241: --------------------------------------------------------------
1242: -- Load the cache with the GREs under the given Legal Employer
1243: --------------------------------------------------------------
1244: pay_mx_yrend_arch.load_gre (ln_business_group_id,
1245: ln_legal_employer_id,
1246: ld_end_date);
1247: END IF;
1248: