APPS.FV_GEN_ARTRX_REIMB_PROC dependencies on FND_FLEX_VALUE_CHILDREN_V

Line 289: from FND_FLEX_VALUE_CHILDREN_V

285: BEGIN
286: --Finding Child values if expenditure account on federal Financials options form is a parent account
287:
288: select count(distinct(FLEX_VALUE)) into l_exp_child
289: from FND_FLEX_VALUE_CHILDREN_V
290: where FLEX_VALUE_SET_ID = g_ussgl_flex_value_set_id
291: start with PARENT_FLEX_VALUE = g_expenditure_acc
292: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE;
293:

Line 297: from FND_FLEX_VALUE_CHILDREN_V

293:
294: If l_exp_child > 0 THEN
295:
296: l_sql_exp_child := 'select distinct(FLEX_VALUE)
297: from FND_FLEX_VALUE_CHILDREN_V
298: where FLEX_VALUE_SET_ID = '||g_ussgl_flex_value_set_id||'
299: start with PARENT_FLEX_VALUE = '||''''||g_expenditure_acc||''''||'
300: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE';
301:

Line 317: from FND_FLEX_VALUE_CHILDREN_V

313:
314:
315: BEGIN
316: select count(distinct(FLEX_VALUE)) into l_rev_child
317: from FND_FLEX_VALUE_CHILDREN_V
318: where FLEX_VALUE_SET_ID = g_ussgl_flex_value_set_id
319: start with PARENT_FLEX_VALUE = g_revenue_acc
320: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE;
321:

Line 326: from FND_FLEX_VALUE_CHILDREN_V

322:
323: If l_rev_child >0 THEN
324:
325: l_sql_rev_child := 'select distinct(FLEX_VALUE)
326: from FND_FLEX_VALUE_CHILDREN_V
327: where FLEX_VALUE_SET_ID = '||g_ussgl_flex_value_set_id||'
328: start with PARENT_FLEX_VALUE = '||''''||g_revenue_acc||''''||'
329: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE';
330:

Line 345: from FND_FLEX_VALUE_CHILDREN_V

341: log(C_STATE_LEVEL, l_module, 'Child Accounts of g_revenue_acc: '||l_rev_child);
342:
343: BEGIN
344: select count(distinct(FLEX_VALUE)) into l_adv_child
345: from FND_FLEX_VALUE_CHILDREN_V
346: where FLEX_VALUE_SET_ID = g_ussgl_flex_value_set_id
347: start with PARENT_FLEX_VALUE = g_advance_acc
348: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE;
349:

Line 353: from FND_FLEX_VALUE_CHILDREN_V

349:
350: If l_adv_child >0 THEN
351:
352: l_sql_adv_child := 'select distinct(FLEX_VALUE)
353: from FND_FLEX_VALUE_CHILDREN_V
354: where FLEX_VALUE_SET_ID = '||g_ussgl_flex_value_set_id||'
355: start with PARENT_FLEX_VALUE = '||''''||g_advance_acc||''''||'
356: connect by nocycle prior FLEX_VALUE = PARENT_FLEX_VALUE';
357: