APPS.PA_AGREEMENT_CORE dependencies on PA_CUSTOMERS_V
Line 85: from pa_customers_v where status = 'A' and
81: -- fnd_message.set_name ('PA', 'PA_ALL_WARN_NO_EMPL_REC');
82: ELSE
83: select 1 into cust_exists from dual where exists (
84: Select customer_name, customer_id, customer_number 85: from pa_customers_v where status = 'A' and 86: customer_id = p_customer_id);
87: IF cust_exists = 1
88: THEN RETURN 'Y';
89: END IF;