[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
385: and pac.report_qualifier = pus.state_abbrev
386: and pac.report_category is not null
387: and bg.business_group_id = pac.business_group_id
388: and bg.legislation_code in ('US', 'CA')
389: and hou.organization_id(+) = pay_core_utils.get_parameter('TRANSFER_GRE',pac.legislative_parameters)
390: --
391: -- decode(instr(pac.legislative_parameters,
392: -- 'TRANSFER_GRE'),
393: -- 0, -1,
403: pay_payroll_actions pac
404: where pac.payroll_action_id = p_payroll_action_id
405: and pac.report_category is not null
406: and pac.report_qualifier = 'FED'
407: and hou.organization_id(+) = pay_core_utils.get_parameter('TRANSFER_GRE',pac.legislative_parameters);
408: --
409: -- decode(instr(pac.legislative_parameters,
410: -- 'TRANSFER_GRE'),
411: -- 0, -1,
420: select pud.name
421: from pay_upgrade_definitions_vl pud,
422: pay_payroll_actions pac
423: where pac.payroll_action_id = p_payroll_action_id
424: and pud.short_name = pay_core_utils.get_parameter('UPG_DEF_NAME',pac.legislative_parameters);
425:
426: cursor get_report_type is
427: select pac.report_type
428: from pay_payroll_actions pac