APPS.AP_BAL_PKG dependencies on FND_PROFILE

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

115: AND ffs.id_flex_code = 'GL#'
116: --AND gcc.chart_of_accounts_id = (SELECT chart_of_accounts_id .. B 8973431/8935239
117: AND ffs.id_flex_num = (SELECT chart_of_accounts_id -- B 8973431/8935239
118: FROM gl_access_sets
119: WHERE access_set_id = fnd_profile.value('GL_ACCESS_SET_ID'))
120: AND ffv.flex_value = p_seg_value;
121: ELSE
122: SELECT ffv.description
123: INTO v_value_desc

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

150: SELECT gled.name
151: INTO gc_ledger_name
152: FROM gl_ledgers gled
153: ,gl_access_set_norm_assign gasna
154: WHERE gasna.access_set_id = FND_PROFILE.VALUE('GL_ACCESS_SET_ID')
155: AND gled.ledger_id = gasna.ledger_id
156: AND gled.ledger_category_code = 'PRIMARY';
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN

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

181: INTO ld_period_from_date
182: FROM gl_period_statuses gps
183: WHERE gps.period_name = PERIOD_FROM_PARAM
184: AND gps.application_id = 200
185: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
186:
187: SELECT gps.end_date
188: INTO ld_period_to_date
189: FROM gl_period_statuses gps

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

188: INTO ld_period_to_date
189: FROM gl_period_statuses gps
190: WHERE gps.period_name = PERIOD_TO_PARAM
191: AND gps.application_id = 200
192: AND gps.set_of_books_id = FND_PROFILE.VALUE('GL_SET_OF_BKS_ID');
193: END IF;
194:
195: IF ld_param_from_date <= ld_period_from_date THEN
196: gd_from_date := ld_param_from_date;