DBA Data[Home] [Help]

APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 156: FROM DPP_CUSTOMER_CLAIMS_ALL

152: AND SUPP_DIST_CLAIM_ID=p_claim_line_tbl(i).claim_id;
153: ELSIF l_claim_type='SUPP_CUST_CL' THEN
154: SELECT CUSTOMER_INV_LINE_ID
155: INTO l_transaction_line_id
156: FROM DPP_CUSTOMER_CLAIMS_ALL
157: WHERE transaction_header_id=l_transaction_header_id
158: AND inventory_item_id=p_claim_line_tbl(i).item_id
159: AND SUPP_CUST_CLAIM_ID=p_claim_line_tbl(i).claim_id
160: AND CUST_ACCOUNT_ID=p_claim_line_tbl(i).dpp_cust_account_id;

Line 164: FROM DPP_CUSTOMER_CLAIMS_ALL

160: AND CUST_ACCOUNT_ID=p_claim_line_tbl(i).dpp_cust_account_id;
161: ELSIF l_claim_type='CUST_CL' THEN
162: SELECT CUSTOMER_INV_LINE_ID
163: INTO l_transaction_line_id
164: FROM DPP_CUSTOMER_CLAIMS_ALL
165: WHERE transaction_header_id=l_transaction_header_id
166: AND inventory_item_id=p_claim_line_tbl(i).item_id
167: AND CUSTOMER_CLAIM_ID=p_claim_line_tbl(i).claim_id;
168: END IF;