APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_LOOKUP_CODES

Line 9129: FROM PO_LOOKUP_CODES

9125: INSERT INTO po_session_gt(key, num1, char1)
9126: SELECT p_key,
9127: p_index_tbl(i),
9128: lookup_code
9129: FROM PO_LOOKUP_CODES
9130: WHERE p_contract_type_display_tbl(i) IS NOT NULL
9131: AND x_contract_type_tbl(i) IS null
9132: AND LOOKUP_TYPE IN ('PO_FEDERAL_CONTRACT_TYPES_AMT','PO_FEDERAL_CONTRACT_TYPES_QTY')
9133: AND displayed_field = p_contract_type_display_tbl(i)

Line 9200: FROM PO_LOOKUP_CODES

9196: INSERT INTO po_session_gt(key, num1, char1)
9197: SELECT p_key,
9198: p_index_tbl(i),
9199: lookup_code
9200: FROM PO_LOOKUP_CODES
9201: WHERE p_cost_constraint_display_tbl(i) IS NOT NULL
9202: AND x_cost_constraint_tbl(i) IS null
9203: AND LOOKUP_TYPE = 'PO_FEDERAL_COST_CONSTRAINTS'
9204: AND displayed_field = p_cost_constraint_display_tbl(i);

Line 9270: FROM PO_LOOKUP_CODES

9266: INSERT INTO po_session_gt(key, num1, char1)
9267: SELECT p_key,
9268: p_index_tbl(i),
9269: lookup_code
9270: FROM PO_LOOKUP_CODES
9271: WHERE p_clm_idc_type_display_tbl(i) IS NOT NULL
9272: AND x_clm_idc_type_tbl(i) IS null
9273: AND LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES'
9274: AND displayed_field = p_clm_idc_type_display_tbl(i);