DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 104: FROM dpp_customer_claims_all dcca

100: END;
101:
102: BEGIN
103: SELECT DISTINCT 'Y' INTO l_flag
104: FROM dpp_customer_claims_all dcca
105: WHERE transaction_header_id = p_transaction_header_id
106: AND supplier_claim_created IN ('Y','P') ;
107: SELECT meaning
108: INTO l_process_code

Line 307: FROM dpp_execution_processes dep, dpp_customer_claims_all dcca

303: END;
304:
305: BEGIN
306: SELECT DISTINCT 'Y' INTO l_flag
307: FROM dpp_execution_processes dep, dpp_customer_claims_all dcca
308: WHERE dep.transaction_header_id = dcca.transaction_header_id
309: AND dcca.transaction_header_id = p_transaction_header_id
310: AND dep.process_code = 'CUSTINVCL'
311: AND supplier_claim_created IN ('N','P') ;