eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W2_INFO_PKG dependencies on HR_US_W2_REP

Line 165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

161: and hl.location_id = paf.location_id
162: and hou.organization_id = paf.organization_id
163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

162: and hou.organization_id = paf.organization_id
163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

Line 167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',

Line 169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

Line 170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

Line 172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

Line 174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',

Line 176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

Line 177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

Line 179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));

Line 180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:

Line 181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:
185: --changes for Bug 8876216

Line 182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:
185: --changes for Bug 8876216
186:

Line 183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));

179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:
185: --changes for Bug 8876216
186:
187: CURSOR c_get_asg_action IS