DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on OKC_K_LINES_B

Line 1274: FROM okc_k_headers_b okh, okc_k_lines_b okl

1270: CURSOR get_oks_line_end_dt1(p_contract_number IN VARCHAR2,
1271: p_contract_modifier IN VARCHAR2)
1272: IS
1273: SELECT trunc(min(okl.end_date)), trunc(okh.start_date)
1274: FROM okc_k_headers_b okh, okc_k_lines_b okl
1275: WHERE OKL.DNZ_CHR_ID = OKH.ID
1276: AND OKH.CONTRACT_NUMBER = p_contract_number
1277: AND OKH.CONTRACT_NUMBER_MODIFIER = p_contract_modifier
1278: GROUP BY OKH.ID, OKH.start_date;

Line 1283: FROM okc_k_headers_b okh, okc_k_lines_b okl

1279:
1280: CURSOR get_oks_line_end_dt2(p_contract_number IN VARCHAR2)
1281: IS
1282: SELECT trunc(min(okl.end_date)), trunc(okh.start_date)
1283: FROM okc_k_headers_b okh, okc_k_lines_b okl
1284: WHERE OKL.DNZ_CHR_ID = OKH.ID
1285: AND OKH.CONTRACT_NUMBER = p_contract_number
1286: GROUP BY OKH.ID, OKH.start_date;
1287: