APPS.PA_AGREEMENT_CORE dependencies on DUAL

Line 83: select 1 into cust_exists from dual where exists (

79: IS NULL THEN
80: RETURN 'N';
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

Line 112: From Dual

108: ) RETURN VARCHAR2 is
109: type_exists number;
110: BEGIN
111: Select 1 into type_exists
112: From Dual
113: Where Exists (
114: select 0
115: from pa_agreement_types atp, ra_terms rt
116: where atp.term_id = rt.term_id(+)

Line 183: From Dual

179: term_exists number;
180: BEGIN
181: Select 1
182: into Term_exists
183: From Dual
184: Where Exists (
185: select 0
186: from ra_terms
187: where trunc(sysdate) between start_date_active

Line 214: from Dual Where Exists (

210: IS
211: person_id_exists number;
212: BEGIN
213: select 1 into Person_Id_Exists
214: from Dual Where Exists (
215: select 0 from pa_employees
216: where person_id = p_owned_by_person_id);
217: IF Person_Id_Exists = 1
218: THEN RETURN 'Y';