APPS.HR_DU_DI_INSERT dependencies on HR_API_MODULES

Line 424: hr_api_modules api,

420:
421: CURSOR csr_API_name IS
422: SELECT upper(des.value)
423: FROM hr_du_upload_headers head,
424: hr_api_modules api,
425: hr_du_descriptors des
426: WHERE head.upload_header_id = p_upload_header_id
427: AND head.upload_header_id = des.upload_header_id
428: AND head.api_module_id = api.api_module_id

Line 727: FROM hr_api_modules api,

723: l_string_length NUMBER;
724:
725: CURSOR csr_api_name IS
726: SELECT api.module_NAME
727: FROM hr_api_modules api,
728: hr_du_upload_headers head
729: WHERE head.upload_header_id = p_upload_header_id
730: AND head.api_module_id = api.api_module_id;
731:

Line 1193: FROM hr_api_modules api,

1189: --API table
1190: CURSOR csr_files IS
1191: SELECT des.descriptor_id, api.api_module_id, upper(api.module_NAME),
1192: des.VALUE
1193: FROM hr_api_modules api,
1194: hr_du_descriptors des
1195: WHERE upper(api.module_NAME) = upper(des.DESCRIPTOR)
1196: AND des.DESCRIPTOR_TYPE = 'F'
1197: AND des.upload_id = p_upload_id;

Line 1208: FROM hr_api_modules api,

1204: FROM hr_du_descriptors des
1205: WHERE des.DESCRIPTOR_TYPE = 'F'
1206: AND des.upload_id = p_upload_id
1207: AND upper(des.DESCRIPTOR) NOT IN ( SELECT upper(des.DESCRIPTOR)
1208: FROM hr_api_modules api,
1209: hr_du_descriptors des
1210: WHERE upper(api.module_NAME) =
1211: upper(des.DESCRIPTOR)
1212: AND des.DESCRIPTOR_TYPE = 'F'