DBA Data[Home] [Help]

APPS.IGI_BUD dependencies on IGI_BUD_PROFILE_CODES

Line 140: FROM igi_bud_profile_codes pc

136: x NUMBER;
137: BEGIN
138: SELECT 1
139: INTO x
140: FROM igi_bud_profile_codes pc
141: WHERE pc.set_of_books_id = p_set_of_books_id
142: AND pc.profile_code = p_profile_code
143: AND nvl(pc.start_date_active, sysdate-1) <= sysdate
144: AND nvl(pc.end_date_active, sysdate+1) > sysdate;

Line 755: FROM igi_bud_profile_codes

751: WHERE line.reference_3 <> 'MANUAL'
752: AND line.reference_3 is not null
753: AND line.reference_3 not in (
754: SELECT profile_code
755: FROM igi_bud_profile_codes
756: WHERE set_of_books_id = p_set_of_books_id
757: AND sysdate >= nvl(start_date_Active,sysdate-1)
758: AND sysdate <= nvl(end_date_active,sysdate+1));
759: