APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_UPLOAD_HEADERS

Line 264: hr_du_upload_headers head

260: CURSOR csr_api_file IS
261: SELECT des.descriptor
262: FROM hr_api_modules api,
263: hr_du_descriptors des,
264: hr_du_upload_headers head
265: WHERE api.api_module_id = l_parent_api_module_id
266: AND head.upload_header_id = p_upload_header_id
267: AND head.upload_id = des.upload_id
268: AND upper(api.module_name) = upper(des.descriptor);

Line 1126: hr_du_upload_headers head

1122: CURSOR csr_api_file IS
1123: SELECT des.value
1124: FROM hr_api_modules api,
1125: hr_du_descriptors des,
1126: hr_du_upload_headers head
1127: WHERE api.api_module_id = p_api_module_id
1128: AND head.upload_header_id = p_upload_header_id
1129: AND head.upload_id = des.upload_id
1130: AND upper(api.module_name) = upper(des.descriptor);

Line 1341: FROM hr_du_upload_headers

1337: AND desc3.upload_header_id = desc1.upload_header_id;
1338:
1339: CURSOR csr_header_to_api IS
1340: SELECT api_module_id
1341: FROM hr_du_upload_headers
1342: WHERE upload_header_id = l_temp_upload_header;
1343:
1344:
1345: CURSOR csr_field_value IS

Line 1415: hr_du_upload_headers head

1411: --
1412: SELECT line.upload_line_id, line.upload_header_id
1413: INTO l_upload_line_id, l_upload_header_id
1414: FROM hr_du_upload_lines line,
1415: hr_du_upload_headers head
1416: WHERE head.upload_id = p_upload_id
1417: AND head.api_module_id = l_api_module_id
1418: AND line.upload_header_id = head.upload_header_id
1419: AND line.status = 'NS'

Line 1471: hr_du_upload_headers head

1467:
1468: SELECT line.upload_line_id, line.upload_header_id
1469: INTO l_upload_line_id, l_upload_header_id
1470: FROM hr_du_upload_lines line,
1471: hr_du_upload_headers head
1472: WHERE head.upload_id = p_upload_id
1473: AND head.api_module_id = l_api_module_id
1474: AND line.upload_header_id = head.upload_header_id
1475: AND line.status = 'NS'

Line 1750: 'FROM hr_du_upload_headers head, ' ||

1746: -- *************************************************************************************************
1747:
1748:
1749: l_built_up_string1 := 'SELECT head.upload_header_id '||
1750: 'FROM hr_du_upload_headers head, ' ||
1751: 'hr_du_descriptors des '||
1752: 'WHERE head.upload_id = ' || p_upload_id ||
1753: ' AND head.api_module_id = ' ||
1754: g_insert_table(l_target_api_module).r_api_id ||

Line 1964: FROM hr_du_upload_headers head,

1960:
1961:
1962: DELETE FROM HR_DU_UPLOAD_LINES
1963: WHERE UPLOAD_HEADER_ID IN (SELECT head.upload_header_id
1964: FROM hr_du_upload_headers head,
1965: hr_du_descriptors des
1966: WHERE head.upload_id = p_upload_id
1967: AND head.upload_header_id = des.upload_header_id
1968: AND upper(des.descriptor) = 'REFERENCING'

Line 1976: FROM hr_du_upload_headers

1972:
1973: UPDATE hr_du_upload_lines
1974: SET status = 'NS'
1975: WHERE UPLOAD_HEADER_ID IN (SELECT upload_header_id
1976: FROM hr_du_upload_headers
1977: WHERE upload_id = p_upload_id)
1978: AND status <> 'NS';
1979: COMMIT;
1980: