DBA Data[Home] [Help]

APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on DPP_TRANSACTION_CLAIMS_ALL

Line 54: l_claim_type DPP_TRANSACTION_CLAIMS_ALL.CLAIM_TYPE%TYPE;

50: l_claim_line_tbl claim_line_tbl_type := p_claim_line_tbl;
51: --l_claim_line_rec claim_line_rec_type ;
52: l_error_index NUMBER;
53: l_transaction_header_id DPP_TRANSACTION_HEADERS_ALL.transaction_header_id%TYPE;
54: l_claim_type DPP_TRANSACTION_CLAIMS_ALL.CLAIM_TYPE%TYPE;
55: l_transaction_line_id DPP_TRANSACTION_LINES_ALL.transaction_line_id%TYPE;
56:
57: l_sql_statement VARCHAR2(200);
58: l_sla_line_tbl_type sla_line_tbl_type;

Line 94: FROM DPP_TRANSACTION_CLAIMS_ALL

90: SELECT TRANSACTION_HEADER_ID,
91: CLAIM_TYPE
92: INTO l_transaction_header_id,
93: l_claim_type
94: FROM DPP_TRANSACTION_CLAIMS_ALL
95: WHERE CLAIM_ID=p_claim_id;
96:
97: EXCEPTION
98: