APPS.HR_CCMGR_SS dependencies on HR_API_TRANSACTIONS

Line 53: and not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t,

49: and class.org_information_context = 'CLASS'
50: and class.org_information2 = 'Y'
51: and class.organization_id = cm.organization_id)
52: /* Excluding pending approval */
53: and not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t,
54: hr_api_transaction_values v
55: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
56: and s.transaction_id = t.transaction_id and status = 'Y'
57: and s.transaction_step_id = v.transaction_step_id