DBA Data[Home] [Help]

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;