[Home] [Help]
50: mreid 115.21 24-FEB-2003 Bug 2802446 - corrected possible
51: invalid number in US archive
52: retrieval (added Hint)
53: SuSivasu 115.22 04-APR-2003 Fixed the issue in Bug 2802446, where by
54: using pay_core_utils.get_parameter to extract GRE info.
55: JBarker 115.23 11-JUN-2003 Added decode_cheque_type function
56: alogue 115.24 24-FEB-2003 Bug 3166075 - fix v_name procedure for
57: archiver.
58: tvankayl 115.25 29-DEC-2003 Bug 3261430 - v_name procedure
386: and pac.report_qualifier = pus.state_abbrev
387: and pac.report_category is not null
388: and bg.business_group_id = pac.business_group_id
389: and bg.legislation_code in ('US', 'CA')
390: and hou.organization_id(+) = pay_core_utils.get_parameter('TRANSFER_GRE',pac.legislative_parameters)
391: --
392: -- decode(instr(pac.legislative_parameters,
393: -- 'TRANSFER_GRE'),
394: -- 0, -1,
404: pay_payroll_actions pac
405: where pac.payroll_action_id = p_payroll_action_id
406: and pac.report_category is not null
407: and pac.report_qualifier = 'FED'
408: and hou.organization_id(+) = pay_core_utils.get_parameter('TRANSFER_GRE',pac.legislative_parameters);
409: --
410: -- decode(instr(pac.legislative_parameters,
411: -- 'TRANSFER_GRE'),
412: -- 0, -1,
421: select pud.name
422: from pay_upgrade_definitions_vl pud,
423: pay_payroll_actions pac
424: where pac.payroll_action_id = p_payroll_action_id
425: and pud.short_name = pay_core_utils.get_parameter('UPG_DEF_NAME',pac.legislative_parameters);
426:
427: cursor get_report_type is
428: select pac.report_type
429: from pay_payroll_actions pac