APPS.PER_MX_SS_AFFILIATION dependencies on PER_MX_SS_AFFILIATION

Line 1: PACKAGE BODY PER_MX_SS_AFFILIATION AS

1: PACKAGE BODY PER_MX_SS_AFFILIATION AS
2: /* $Header: permxssaffiltion.pkb 120.17.12020000.2 2012/08/28 06:58:38 jeisaac ship $ */
3: /*
4: ******************************************************************
5: * *

Line 19: Package Name : PER_MX_SS_AFFILIATION

15: * the express written permission of Oracle Corporation, *
16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19: Package Name : PER_MX_SS_AFFILIATION
20: Package File Name : permxssaffiltion.pkb
21:
22: Description : Used for Social Security Affiliation report.
23:

Line 400: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,

396: FROM per_assignments_f
397: WHERE business_group_id = '||g_business_group||'
398: /*AND fnd_date.canonical_to_date('''||l_new_end_date
399: ||''') BETWEEN effective_start_date AND effective_end_date*/
400: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,
401: business_group_id,
402: soft_coding_keyflex_id,
403: fnd_date.canonical_to_date('''||
404: l_new_end_date||''')) IN

Line 1425: g_proc_name := 'PER_MX_SS_AFFILIATION.';

1421: END GEN_XML_FOOTER;
1422:
1423: BEGIN
1424: --hr_utility.trace_on(null, 'MX_IDC');
1425: g_proc_name := 'PER_MX_SS_AFFILIATION.';
1426: g_debug := hr_utility.debug_enabled;
1427: g_document_type := 'MX_SS_AFFL';
1428: END PER_MX_SS_AFFILIATION;

Line 1428: END PER_MX_SS_AFFILIATION;

1424: --hr_utility.trace_on(null, 'MX_IDC');
1425: g_proc_name := 'PER_MX_SS_AFFILIATION.';
1426: g_debug := hr_utility.debug_enabled;
1427: g_document_type := 'MX_SS_AFFL';
1428: END PER_MX_SS_AFFILIATION;