DBA Data[Home] [Help]

APPS.PA_AGREEMENT_CORE dependencies on RA_TERMS

Line 115: from pa_agreement_types atp, ra_terms rt

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(+)
117: and trunc(sysdate) between trunc(atp.start_date_active)
118: and trunc(nvl(atp.end_date_active,sysdate))
119: and atp.agreement_type = p_agreement_type);

Line 186: from ra_terms

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
188: and nvl(end_date_active, trunc(sysdate))
189: and term_id = p_term_id);
190: