APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_DESCRIPTORS

Line 263: hr_du_descriptors des,

259:
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

Line 980: FROM hr_du_descriptors des1,

976: IS
977:
978: CURSOR csr_apis IS
979: SELECT api.api_module_id, des2.upload_header_id
980: FROM hr_du_descriptors des1,
981: hr_du_descriptors des2,
982: hr_du_descriptors des3,
983: hr_api_modules api
984: WHERE des1.upload_id = p_upload_id

Line 981: hr_du_descriptors des2,

977:
978: CURSOR csr_apis IS
979: SELECT api.api_module_id, des2.upload_header_id
980: FROM hr_du_descriptors des1,
981: hr_du_descriptors des2,
982: hr_du_descriptors des3,
983: hr_api_modules api
984: WHERE des1.upload_id = p_upload_id
985: and upper(des1.descriptor) = 'API'

Line 982: hr_du_descriptors des3,

978: CURSOR csr_apis IS
979: SELECT api.api_module_id, des2.upload_header_id
980: FROM hr_du_descriptors des1,
981: hr_du_descriptors des2,
982: hr_du_descriptors des3,
983: hr_api_modules api
984: WHERE des1.upload_id = p_upload_id
985: and upper(des1.descriptor) = 'API'
986: and des1.descriptor_type = 'D'

Line 1002: FROM hr_du_descriptors

998: --cursor checks to see if there are any files to be processed
999: --meaning there maybe CP files.
1000: CURSOR csr_any_files IS
1001: SELECT value
1002: FROM hr_du_descriptors
1003: WHERE upload_id = p_upload_id
1004: and upper(descriptor) = 'API'
1005: and descriptor_type = 'D';
1006:

Line 1125: hr_du_descriptors des,

1121:
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

Line 1326: FROM hr_du_descriptors desc1,

1322:
1323:
1324: CURSOR csr_starting_point IS
1325: SELECT desc1.UPLOAD_HEADER_ID
1326: FROM hr_du_descriptors desc1,
1327: hr_du_descriptors desc2,
1328: hr_du_descriptors desc3
1329: WHERE upper(desc1.DESCRIPTOR) = 'STARTING POINT'
1330: AND upper(desc1.VALUE) = 'YES'

Line 1327: hr_du_descriptors desc2,

1323:
1324: CURSOR csr_starting_point IS
1325: SELECT desc1.UPLOAD_HEADER_ID
1326: FROM hr_du_descriptors desc1,
1327: hr_du_descriptors desc2,
1328: hr_du_descriptors desc3
1329: WHERE upper(desc1.DESCRIPTOR) = 'STARTING POINT'
1330: AND upper(desc1.VALUE) = 'YES'
1331: AND desc1.upload_id = p_upload_id

Line 1328: hr_du_descriptors desc3

1324: CURSOR csr_starting_point IS
1325: SELECT desc1.UPLOAD_HEADER_ID
1326: FROM hr_du_descriptors desc1,
1327: hr_du_descriptors desc2,
1328: hr_du_descriptors desc3
1329: WHERE upper(desc1.DESCRIPTOR) = 'STARTING POINT'
1330: AND upper(desc1.VALUE) = 'YES'
1331: AND desc1.upload_id = p_upload_id
1332: AND upper(desc2.DESCRIPTOR) = 'REFERENCING'

Line 1751: 'hr_du_descriptors des '||

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 ||
1755: 'AND des.upload_header_id = head.upload_header_id ' ||

Line 1965: hr_du_descriptors des

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'
1969: AND upper(des.value) = 'PC')