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.49.12020000.8 2013/02/06 12:46:12 jeisaac ship $ */
3: /* +=========================================================================+
4: | Copyright (c) 2005 Oracle Corporation |
5: | IDC, Hyderabad, India |

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

850: AND paa.source_action_id IS NULL
851: AND paf.assignment_id = paa.assignment_id
852: AND ppa.effective_date BETWEEN paf.effective_start_date
853: AND paf.effective_end_date
854: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
855: AND :payroll_action_id > 0
856: ORDER BY paf.person_id';
857: ELSE
858:

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

872: AND paa.source_action_id IS NULL
873: AND paf.assignment_id = paa.assignment_id
874: AND ppa.effective_date BETWEEN paf.effective_start_date
875: AND paf.effective_end_date
876: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
877: AND EXISTS
878: (SELECT ''x''
879: FROM hr_assignment_sets has,
880: hr_assignment_set_amendments hasa,

Line 2704: gv_package := 'pay_mx_yrend_arch';

2700: END archive_code;
2701:
2702: BEGIN
2703: --hr_utility.trace_on (NULL, 'MX_IDC');
2704: gv_package := 'pay_mx_yrend_arch';
2705: END pay_mx_yrend_arch;

Line 2705: END pay_mx_yrend_arch;

2701:
2702: BEGIN
2703: --hr_utility.trace_on (NULL, 'MX_IDC');
2704: gv_package := 'pay_mx_yrend_arch';
2705: END pay_mx_yrend_arch;