DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_MX_YREND_ARCH

Line 1: PACKAGE BODY PAY_MX_YREND_ARCH AS

1: PACKAGE BODY PAY_MX_YREND_ARCH AS
2: /* $Header: paymxyrendarch.pkb 120.32.12010000.4 2008/08/06 06:37:33 ubhat ship $ */
3: /* +=========================================================================+
4: | Copyright (c) 2005 Oracle Corporation |
5: | IDC, Hyderabad, India |

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

637: AND paa.source_action_id IS NULL
638: AND paf.assignment_id = paa.assignment_id
639: AND ppa.effective_date BETWEEN paf.effective_start_date
640: AND paf.effective_end_date
641: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
642: AND :payroll_action_id > 0
643: ORDER BY paf.person_id';
644: ELSE
645:

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

659: AND paa.source_action_id IS NULL
660: AND paf.assignment_id = paa.assignment_id
661: AND ppa.effective_date BETWEEN paf.effective_start_date
662: AND paf.effective_end_date
663: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
664: AND EXISTS
665: (SELECT ''x''
666: FROM hr_assignment_sets has,
667: hr_assignment_set_amendments hasa,

Line 2261: gv_package := 'pay_mx_yrend_arch';

2257: END archive_code;
2258:
2259: BEGIN
2260: --hr_utility.trace_on (NULL, 'MX_IDC');
2261: gv_package := 'pay_mx_yrend_arch';
2262: END pay_mx_yrend_arch;

Line 2262: END pay_mx_yrend_arch;

2258:
2259: BEGIN
2260: --hr_utility.trace_on (NULL, 'MX_IDC');
2261: gv_package := 'pay_mx_yrend_arch';
2262: END pay_mx_yrend_arch;