APPS.OE_VALIDATE_AGREEMENT dependencies on OE_AGREEMENTS

Line 861: from oe_agreements

857: IF p_Agreement_rec.name is NOT NULL THEN
858: /* Check for end dates overlap */
859:
860: select 'VALID' into l_dummy
861: from oe_agreements
862: where name = p_Agreement_rec.name
863: and ( nvl( trunc(start_date_active),sysdate) between
864: nvl(p_Agreement_rec.start_date_active, sysdate)
865: and

Line 913: from oe_agreements

909: /* Check for start dates */
910:
911: select count(*)
912: into l_count
913: from oe_agreements
914: where name = p_Agreement_rec.name
915: and nvl(p_Agreement_rec.start_date_active , sysdate)
916: BETWEEN nvl(trunc(start_date_active), sysdate) and
917: nvl(trunc(end_date_active),sysdate)

Line 950: from oe_agreements

946: BEGIN
947:
948: SELECT count(*)
949: into l_count
950: from oe_agreements
951: where name = p_Agreement_rec.name
952: -- and revision = '1' /* User may enter revision 2 to start with */
953: and ( start_date_active is null
954: or

Line 1016: FROM OE_AGREEMENTS

1012: /* Check Agreement Exists */
1013: IF p_Agreement_rec.name is NOT NULL THEN
1014: SELECT 'VALID'
1015: into l_dummy
1016: FROM OE_AGREEMENTS
1017: where name = p_Agreement_rec.name
1018: and revision = p_Agreement_rec.revision;
1019:
1020: