APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on DPP_TRANSACTION_LINES_ALL

Line 55: l_transaction_line_id DPP_TRANSACTION_LINES_ALL.transaction_line_id%TYPE;

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;
59: l_processed_flag DPP_XLA_HEADERS.PROCESSED_FLAG%TYPE := 'N';

Line 149: FROM DPP_TRANSACTION_LINES_ALL

145: BEGIN
146: IF l_claim_type='SUPP_DSTR_CL' OR l_claim_type='SUPP_DSTR_INC_CL' THEN --ANBBALAS: Included the condition l_claim_type='SUPP_DSTR_INC_CL' for Price Increase
147: SELECT transaction_line_id
148: INTO l_transaction_line_id
149: FROM DPP_TRANSACTION_LINES_ALL
150: WHERE transaction_header_id=l_transaction_header_id
151: AND inventory_item_id=p_claim_line_tbl(i).item_id
152: AND SUPP_DIST_CLAIM_ID=p_claim_line_tbl(i).claim_id;
153: ELSIF l_claim_type='SUPP_CUST_CL' THEN