APPS.AP_BAL_PKG dependencies on FND_PROFILE

Line 112: WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID'))

108: AND fseg.flex_value_set_id = ffv.flex_value_set_id
109: AND ffs.id_flex_code = 'GL#'
110: AND gcc.chart_of_accounts_id = (SELECT chart_of_accounts_id
111: FROM gl_access_sets
112: WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID'))
113: AND ffv.flex_value = p_seg_value;
114: ELSE
115: SELECT ffv.description
116: INTO v_value_desc

Line 147: WHERE gasna.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')

143: SELECT gled.name
144: INTO gc_ledger_name
145: FROM gl_ledgers gled
146: ,gl_access_set_norm_assign gasna
147: WHERE gasna.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')
148: AND gled.ledger_id = gasna.ledger_id
149: AND gled.ledger_category_code = 'PRIMARY';
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN

Line 178: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

174: INTO ld_period_from_date
175: FROM gl_period_statuses gps
176: WHERE gps.period_name = PERIOD_FROM_PARAM
177: AND gps.application_id = 200
178: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
179:
180: SELECT gps.end_date
181: INTO ld_period_to_date
182: FROM gl_period_statuses gps

Line 185: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');

181: INTO ld_period_to_date
182: FROM gl_period_statuses gps
183: WHERE gps.period_name = PERIOD_TO_PARAM
184: AND gps.application_id = 200
185: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
186: END IF;
187:
188: IF ld_param_from_date <= ld_period_from_date THEN
189: gd_from_date := ld_param_from_date;