APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on PAY_MX_ISR_FORMAT37

Line 1: PACKAGE BODY PAY_MX_ISR_FORMAT37_INFO as

1: PACKAGE BODY PAY_MX_ISR_FORMAT37_INFO as
2: /* $Header: paymxformat37dt.pkb 120.9.12000000.6 2007/09/17 22:03:39 vpandya noship $ */
3:
4: g_package CONSTANT VARCHAR2(33) := 'pay_mx_isr_format37_info.';
5:

Line 4: g_package CONSTANT VARCHAR2(33) := 'pay_mx_isr_format37_info.';

1: PACKAGE BODY PAY_MX_ISR_FORMAT37_INFO as
2: /* $Header: paymxformat37dt.pkb 120.9.12000000.6 2007/09/17 22:03:39 vpandya noship $ */
3:
4: g_package CONSTANT VARCHAR2(33) := 'pay_mx_isr_format37_info.';
5:
6: -- flag to write the debug messages in the concurrent program log file
7: g_concurrent_flag VARCHAR2(1) ;
8: -- flag to write the debug messages in the trace file

Line 271: substr(pay_mx_isr_format37.get_parameter(''FOLIO_NUMBER'',

267: replace(ER_LEGAL_REP_RFC_ID,''-'','''') ER_LEGAL_REP_RFC_ID,
268: ER_LEGAL_REP_CURP ER_LEGAL_REP_CURP,
269: ER_TAX_SUBSIDY_PCT ER_TAX_SUBSIDY_PCT,
270: TAX_SUBSIDY_PCT TAX_SUBSIDY_PCT,
271: substr(pay_mx_isr_format37.get_parameter(''FOLIO_NUMBER'',
272: ppa.legislative_parameters),1,9) FOLIO_NUMBER,
273: To_char(fnd_date.canonical_to_date(ltrim(rtrim(
274: pay_mx_isr_format37.get_parameter(''FOLIO_DATE'',
275: ppa.legislative_parameters)))),

Line 274: pay_mx_isr_format37.get_parameter(''FOLIO_DATE'',

270: TAX_SUBSIDY_PCT TAX_SUBSIDY_PCT,
271: substr(pay_mx_isr_format37.get_parameter(''FOLIO_NUMBER'',
272: ppa.legislative_parameters),1,9) FOLIO_NUMBER,
273: To_char(fnd_date.canonical_to_date(ltrim(rtrim(
274: pay_mx_isr_format37.get_parameter(''FOLIO_DATE'',
275: ppa.legislative_parameters)))),
276: ''DD/MM/YYYY'') FOLIO_DATE
277: from pay_mx_isr_tax_format37_v pfv,
278: pay_payroll_actions ppa

Line 357: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),

353:
354: CURSOR c_get_params IS
355: SELECT paa1.serial_number, -- archiver person id
356: paa1.payroll_action_id, -- archiver payroll_action_id
357: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
358: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
359: pai.effective_date
360: FROM pay_assignment_actions paa,
361: pay_payroll_actions ppa,

Line 358: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),

354: CURSOR c_get_params IS
355: SELECT paa1.serial_number, -- archiver person id
356: paa1.payroll_action_id, -- archiver payroll_action_id
357: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
358: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
359: pai.effective_date
360: FROM pay_assignment_actions paa,
361: pay_payroll_actions ppa,
362: pay_assignment_actions paa1,

Line 505: END PAY_MX_ISR_FORMAT37_INFO ;

501:
502: END get_headers ;
503:
504:
505: END PAY_MX_ISR_FORMAT37_INFO ;