APPS.IGI_BUD dependencies on IGI_BUD_PROFILE_PERIODS

Line 56: FROM igi_bud_profile_periods

52: ( p_first_period NUMBER
53: , p_last_period NUMBER
54: ) IS
55: SELECT period_ratio
56: FROM igi_bud_profile_periods
57: WHERE profile_code = p_profile_code
58: AND set_of_books_id = p_Set_Of_Books_Id
59: AND period_number BETWEEN
60: p_first_period AND p_last_period

Line 77: FROM igi_bud_profile_periods

73: SELECT max(period_number)
74: , sum(period_ratio)
75: INTO l_Max_Period_Number
76: , l_Total_Ratio
77: FROM igi_bud_profile_periods
78: WHERE profile_code = p_Profile_Code
79: AND set_of_books_id = p_Set_Of_Books_Id
80: AND period_number BETWEEN p_Start_Period
81: AND decode(p_Max_Period_Number

Line 194: FROM IGI_BUD_PROFILE_PERIODS jupp

190: p_period_type VARCHAR2(30);
191:
192: CURSOR periods IS
193: SELECT period_number,period_ratio
194: FROM IGI_BUD_PROFILE_PERIODS jupp
195: WHERE jupp.PROFILE_CODE = p_profile_code
196: AND jupp.SET_OF_BOOKS_ID = p_sob_id;
197:
198: CURSOR totals_nyb IS

Line 201: FROM IGI_BUD_PROFILE_PERIODS jupp

197:
198: CURSOR totals_nyb IS
199: SELECT sum(nvl(jupp.period_ratio,0)) total
200: , max(nvl(jubjl.period_number,0))
201: FROM IGI_BUD_PROFILE_PERIODS jupp
202: , IGI_BUD_JOURNAL_PERIODS jubjl
203: WHERE jupp.PROFILE_CODE = p_profile_code
204: AND jupp.SET_OF_BOOKS_ID = p_sob_id
205: AND jubjl.BE_BATCH_ID = p_batch_id

Line 213: FROM IGI_BUD_PROFILE_PERIODS jupp

209:
210: CURSOR periods_nyb IS
211: SELECT jubjl.period_number
212: , period_ratio
213: FROM IGI_BUD_PROFILE_PERIODS jupp
214: , IGI_BUD_JOURNAL_PERIODS jubjl
215: WHERE jupp.PROFILE_CODE = p_profile_code
216: AND jupp.SET_OF_BOOKS_ID = p_sob_id
217: AND jupp.PERIOD_NUMBER = jubjl.PERIOD_NUMBER