APPS.ICX_CAT_UTIL_PVT dependencies on PO_LINES_ALL

Line 945: FROM PO_HEADERS_ALL_SEC ph,PO_LINES_ALL pl

941: --- bug 12792244 start
942:
943: SELECT ph.authorization_status
944: INTO l_auth_status
945: FROM PO_HEADERS_ALL_SEC ph,PO_LINES_ALL pl
946: WHERE pl.po_line_id=p_po_line_id
947: AND ph.po_header_id = pl.po_header_id;
948:
949:

Line 997: FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl

993: l_err_loc := 300;
994:
995: SELECT 1
996: INTO l_status
997: FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl
998: WHERE pl.po_line_id = p_po_line_id
999: AND ph.po_header_id = pl.po_header_id
1000: AND ph.approved_date IS NOT NULL
1001: AND ph.authorization_status NOT IN ('REJECTED', 'INCOMPLETE')

Line 1050: FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl

1046: l_status := 0;
1047:
1048: SELECT 1
1049: INTO l_status
1050: FROM PO_HEADERS_ALL_SEC ph, po_lines_all pl
1051: WHERE pl.po_line_id = p_po_line_id
1052: AND ph.po_header_id = pl.po_header_id
1053: AND ph.status_lookup_code = 'A'
1054: AND ph.quotation_class_code = 'CATALOG'

Line 1193: po_lines_all pol

1189: elsif(p_line_id is not null and p_line_id <> -2) then
1190: select count(*)
1191: into l_count
1192: from po_headers_all_sec poh,
1193: po_lines_all pol
1194: where poh.po_header_id = pol.po_header_id
1195: and pol.po_line_id = p_line_id;
1196: else
1197: return 1;