APPS.PQH_BUDGET_POOLS_SWI dependencies on PQH_PROCESS_LOG

Line 248: FROM pqh_process_log

244: --added by kgowripe for bug#2875736
245: -- Modifed start with caluse for bug 2880128
246: Cursor csr_process_log_ids IS
247: SELECT process_log_id,object_version_number
248: FROM pqh_process_log
249: WHERE module_cd = 'BUDGET_REALLOCATION'
250: START WITH process_log_id = (SELECT process_log_id
251: FROM pqh_process_log
252: WHERE module_cd = 'BUDGET_REALLOCATION'

Line 251: FROM pqh_process_log

247: SELECT process_log_id,object_version_number
248: FROM pqh_process_log
249: WHERE module_cd = 'BUDGET_REALLOCATION'
250: START WITH process_log_id = (SELECT process_log_id
251: FROM pqh_process_log
252: WHERE module_cd = 'BUDGET_REALLOCATION'
253: AND master_process_log_id IS NULL
254: AND txn_id = p_folder_id)
255: CONNECT BY master_process_log_id = PRIOR process_log_id

Line 314: pqh_process_log_api.delete_process_log(p_process_log_id => plg.process_log_id

310: LOOP
311: hr_utility.set_location(' Process Log Id :' || plg.process_log_id ,25);
312: hr_utility.set_location(' OVN :' || plg.object_version_number ,35);
313:
314: pqh_process_log_api.delete_process_log(p_process_log_id => plg.process_log_id
315: ,p_object_version_number=> plg.object_version_number
316: ,p_effective_date => sysdate);
317: END LOOP;
318: -- Added by mvanakda