DBA Data[Home] [Help]

APPS.PO_CLM_CAR_UTIL dependencies on PO_CLM_TO_FPDS_AWARD_TYP_MAP

Line 715: PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,

711: WHEN no_data_found THEN
712:
713: select ATM.FPDS_AWARD_TYPE INTO l_award_idv_type
714: from
715: PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,
716: PO_HEADERS_MERGE_V POH
717: WHERE
718: POH.PO_HEADER_ID = p_po_header_id AND
719: POH.DRAFT_ID = p_draft_id AND

Line 998: FROM PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,

994: END IF;
995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);
996: SELECT ATM.FPDS_AWARD_TYPE
997: INTO l_award_idv_type
998: FROM PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,
999: PO_HEADERS_MERGE_V POH
1000: WHERE POH.PO_HEADER_ID = p_po_header_id
1001: AND NVL(POH.DRAFT_ID,-1) = p_draft_id
1002: AND ATM.REPORT_TYPE(+) = l_report_type