DBA Data[Home] [Help]

APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 154: FROM DPP_CUSTOMER_CLAIMS_ALL

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

Line 162: FROM DPP_CUSTOMER_CLAIMS_ALL

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