DBA Data[Home] [Help]

APPS.HR_DU_RULES dependencies on HR_DU_UPLOAD_HEADERS

Line 171: hr_du_upload_headers head,

167: CURSOR csr_api_file IS
168: SELECT des2.value
169: FROM hr_du_descriptors des1,
170: hr_du_descriptors des2,
171: hr_du_upload_headers head,
172: hr_du_uploads uplo
173: WHERE head.upload_header_id = p_upload_header_id
174: AND head.upload_id = uplo.upload_id
175: AND head.upload_header_id = des1.upload_header_id

Line 332: hr_du_upload_headers head

328: --in the main header for all API's
329: CURSOR csr_dollar_key IS
330: SELECT des.VALUE
331: FROM hr_du_descriptors des,
332: hr_du_upload_headers head
333: WHERE head.upload_header_id = p_upload_header_id
334: AND head.upload_id = des.upload_id
335: AND des.upload_header_id IS NULL
336: AND upper(des.descriptor) = upper(l_pval_value);

Line 351: hr_du_upload_headers head

347: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS
348: CURSOR csr_user_key IS
349: SELECT column_name
350: FROM hr_du_column_mappings col,
351: hr_du_upload_headers head
352: WHERE upper(col.column_name) = upper(l_pval_value)
353: AND head.upload_header_id = p_upload_header_id
354: AND head.api_module_id = col.api_module_id;
355: