[Home] [Help]
566: 28-JUN-1994 DSAXBY 40.19 Added line to decode statement
567: in reversal routine, to
568: prevent invalid number errors.
569: Delete from pay_costs and
570: pay_quickpay_inclusions when
571: we roll back.
572: Do not attempt to delete from
573: pay_pre_payments, unless we are
574: rolling back a Pre-Payment!
1326: hr_utility.set_location('hrassact.trash_quickpay',10);
1327: end if;
1328: --
1329: -- Enhancement 3368211
1330: -- Delete from both PAY_QUICKPAY_INCLUSIONS and
1331: -- PAY_QUICKPAY_EXCLUSIONS.
1332: --
1333: -- There is a chance the assignment action id exists in both tables if
1334: -- the assignment action was created before the QuickPay Exclusions
1335: -- data model was in use.
1336: delete from pay_quickpay_exclusions
1337: where assignment_action_id = p_action_id;
1338: --
1339: delete from pay_quickpay_inclusions
1340: where assignment_action_id = p_action_id;
1341: --
1342: if g_debug then
1343: hr_utility.set_location('hrassact.trash_quickpay',20);