APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on PAY_MAGTAPE_GENERIC

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

276: ''DD/MM/YYYY'') FOLIO_DATE
277: from pay_mx_isr_tax_format37_v pfv,
278: pay_payroll_actions ppa
279: where ppa.payroll_action_id =
280: pay_magtape_generic.get_parameter_value(''TRANSFER_PAYROLL_ACTION_ID'')
281: and pfv.payroll_action_id = ' || p_arch_payroll_action_id || '
282: and pfv.person_id = ' || p_arch_person_id || '
283: and pfv.legal_employer_id = ' || p_legal_employer_id || '
284: and pfv.effective_date = ''' || p_pai_eff_date || '''

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

362: pay_assignment_actions paa1,
363: pay_payroll_actions ppa1,
364: pay_action_information pai
365: where ppa.payroll_action_id = paa.payroll_action_id
366: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
367: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
368: and paa.serial_number = paa1.assignment_action_id
369: and paa1.payroll_action_id = ppa1.payroll_action_id
370: and ppa1.report_type = 'MX_YREND_ARCHIVE'

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

363: pay_payroll_actions ppa1,
364: pay_action_information pai
365: where ppa.payroll_action_id = paa.payroll_action_id
366: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
367: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
368: and paa.serial_number = paa1.assignment_action_id
369: and paa1.payroll_action_id = ppa1.payroll_action_id
370: and ppa1.report_type = 'MX_YREND_ARCHIVE'
371: and ppa1.action_type = 'X'

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

380: dbg('*********************');
381: dbg('In fetch_format37_xml');
382: dbg('*********************');
383:
384: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))) ;
385: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'))) ;
386:
387: l_position := 1 ;
388: l_amount := 32767 ;

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

381: dbg('In fetch_format37_xml');
382: dbg('*********************');
383:
384: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))) ;
385: -- dbg(to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'))) ;
386:
387: l_position := 1 ;
388: l_amount := 32767 ;
389: