1: PACKAGE BODY PAY_MX_ISR_FORMAT37_INFO as
2: /* $Header: paymxformat37dt.pkb 120.26.12020000.2 2012/07/26 10:59:35 jeisaac ship $ */
3:
4: g_package CONSTANT VARCHAR2(33) := 'pay_mx_isr_format37_info.';
5:
1: PACKAGE BODY PAY_MX_ISR_FORMAT37_INFO as
2: /* $Header: paymxformat37dt.pkb 120.26.12020000.2 2012/07/26 10:59:35 jeisaac ship $ */
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
278: replace(ER_LEGAL_REP_RFC_ID,''-'','''') ER_LEGAL_REP_RFC_ID,
279: ER_LEGAL_REP_CURP ER_LEGAL_REP_CURP,
280: ER_TAX_SUBSIDY_PCT ER_TAX_SUBSIDY_PCT,
281: TAX_SUBSIDY_PCT TAX_SUBSIDY_PCT,
282: substr(pay_mx_isr_format37.get_parameter(''FOLIO_NUMBER'',
283: ppa.legislative_parameters),1,9) FOLIO_NUMBER,
284: To_char(fnd_date.canonical_to_date(ltrim(rtrim(
285: pay_mx_isr_format37.get_parameter(''FOLIO_DATE'',
286: ppa.legislative_parameters)))),
281: TAX_SUBSIDY_PCT TAX_SUBSIDY_PCT,
282: substr(pay_mx_isr_format37.get_parameter(''FOLIO_NUMBER'',
283: ppa.legislative_parameters),1,9) FOLIO_NUMBER,
284: To_char(fnd_date.canonical_to_date(ltrim(rtrim(
285: pay_mx_isr_format37.get_parameter(''FOLIO_DATE'',
286: ppa.legislative_parameters)))),
287: ''DD/MM/YYYY'') FOLIO_DATE
288: from pay_mx_isr_tax_format37_v pfv,
289: pay_payroll_actions ppa
365:
366: CURSOR c_get_params IS
367: SELECT paa1.serial_number, -- archiver person id
368: paa1.payroll_action_id, -- archiver payroll_action_id
369: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
370: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
371: pai.effective_date
372: FROM pay_assignment_actions paa,
373: pay_payroll_actions ppa,
366: CURSOR c_get_params IS
367: SELECT paa1.serial_number, -- archiver person id
368: paa1.payroll_action_id, -- archiver payroll_action_id
369: pay_mx_isr_format37.get_parameter('LEGAL_EMPLOYER_ID',ppa.legislative_parameters),
370: pay_mx_isr_format37.get_parameter('Year',ppa.legislative_parameters),
371: pai.effective_date
372: FROM pay_assignment_actions paa,
373: pay_payroll_actions ppa,
374: pay_assignment_actions paa1,
513:
514: END get_headers ;
515:
516:
517: END PAY_MX_ISR_FORMAT37_INFO ;