1749: , ahc.object_version_number
1750: , ahc.call_package
1751: , ahc.call_procedure
1752: from hr_api_hook_calls ahc
1753: , fnd_product_installations fpi
1754: where ahc.api_hook_id = p_api_hook_id
1755: and ahc.enabled_flag = 'Y'
1756: and ahc.application_id is not null
1757: and ahc.application_id = fpi.application_id
2150: --
2151: cursor csr_app_call_exist is
2152: select 1
2153: from hr_api_hook_calls ahc
2154: , fnd_product_installations fpi
2155: where ahc.api_hook_id = p_api_hook_id
2156: and ahc.enabled_flag = 'Y'
2157: and ahc.application_id is not null
2158: and ahc.application_id = fpi.application_id