APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on PAY_MAGTAPE_GENERIC

Line 291: pay_magtape_generic.get_parameter_value(''TRANSFER_PAYROLL_ACTION_ID'')

287: ''DD/MM/YYYY'') FOLIO_DATE
288: from pay_mx_isr_tax_format37_v pfv,
289: pay_payroll_actions ppa
290: where ppa.payroll_action_id =
291: pay_magtape_generic.get_parameter_value(''TRANSFER_PAYROLL_ACTION_ID'')
292: and pfv.payroll_action_id = ' || p_arch_payroll_action_id || '
293: and pfv.person_id = ' || p_arch_person_id || '
294: and pfv.legal_employer_id = ' || p_legal_employer_id || '
295: and pfv.effective_date = ''' || p_pai_eff_date || '''

Line 378: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

374: pay_assignment_actions paa1,
375: pay_payroll_actions ppa1,
376: pay_action_information pai
377: where ppa.payroll_action_id = paa.payroll_action_id
378: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
379: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
380: and paa.serial_number = paa1.assignment_action_id
381: and paa1.payroll_action_id = ppa1.payroll_action_id
382: and ppa1.report_type = 'MX_YREND_ARCHIVE'

Line 379: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

375: pay_payroll_actions ppa1,
376: pay_action_information pai
377: where ppa.payroll_action_id = paa.payroll_action_id
378: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
379: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
380: and paa.serial_number = paa1.assignment_action_id
381: and paa1.payroll_action_id = ppa1.payroll_action_id
382: and ppa1.report_type = 'MX_YREND_ARCHIVE'
383: and ppa1.action_type = 'X'

Line 396: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))) ;

392: dbg('*********************');
393: dbg('In fetch_format37_xml');
394: dbg('*********************');
395:
396: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))) ;
397: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'))) ;
398:
399: l_position := 1 ;
400: l_amount := 32767 ;

Line 397: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'))) ;

393: dbg('In fetch_format37_xml');
394: dbg('*********************');
395:
396: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))) ;
397: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'))) ;
398:
399: l_position := 1 ;
400: l_amount := 32767 ;
401: