APPS.IRC_VACANCY_COMMIT dependencies on HR_WIP_TRANSACTIONS

Line 179: from hr_wip_transactions

175: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
176: --
177: select transaction_id
178: into transaction_number
179: from hr_wip_transactions
180: where item_key = itemkey
181: and item_type = itemtype;
182: --
183: transaction_id := to_char(transaction_number);

Line 189: from hr_wip_transactions

185: hr_utility.trace('Transaction Id is :' || transaction_id || ':');
186: --
187: select vo_cache
188: into xmlClob
189: from hr_wip_transactions
190: where transaction_id = transaction_number;
191: --
192: parser := xmlparser.newParser;
193: --

Line 450: from hr_wip_transactions

446: hr_utility.trace('Effective date is :' || to_char(l_effective_date) || ':');
447: --
448: select transaction_id
449: into transaction_number
450: from hr_wip_transactions
451: where item_key = itemkey
452: and item_type = itemtype;
453: --
454: transaction_id := to_char(transaction_number);

Line 460: from hr_wip_transactions

456: hr_utility.trace('Transaction Id is :' || transaction_id || ':');
457: --
458: select vo_cache
459: into xmlClob
460: from hr_wip_transactions
461: where transaction_id = transaction_number;
462: --
463: parser := xmlparser.newParser;
464: --