963: p_khr_id IN NUMBER)
964: RETURN VARCHAR2 IS
965: CURSOR l_khr_status_csr IS
966: SELECT STS_CODE
967: FROM okc_k_headers_all_b
968: WHERE ID = p_khr_id;
969:
970: CURSOR l_get_booked_Astloc_csr IS
971: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
1077: p_khr_id IN NUMBER)
1078: RETURN NUMBER IS
1079: CURSOR l_khr_status_csr IS
1080: SELECT STS_CODE
1081: FROM okc_k_headers_all_b
1082: WHERE ID = p_khr_id;
1083:
1084: CURSOR l_get_booked_Astloc_csr IS
1085: SELECT psu.party_site_use_id
1192: p_khr_id IN NUMBER)
1193: RETURN VARCHAR2 IS
1194: CURSOR l_khr_status_csr IS
1195: SELECT STS_CODE
1196: FROM okc_k_headers_all_b
1197: WHERE ID = p_khr_id;
1198:
1199: CURSOR l_get_booked_astnum_csr IS
1200: SELECT FAV.ASSET_NUMBER ASSETNUMBER