DBA Data[Home] [Help]

APPS.GMF_FND_GET_SEGMENT_VAL dependencies on GL_SETS_OF_BOOKS

Line 23: gl_sets_of_books GLS,

19: VAL.flex_value,
20: VAL.description,
21: GLS.chart_of_accounts_id
22: FROM fnd_id_flex_segments FND,
23: gl_sets_of_books GLS,
24: fnd_flex_values_vl VAL
25: WHERE GLS.name = NVL(sobname,GLS.name)
26: AND GLS.chart_of_accounts_id = FND.id_flex_num
27: AND LOWER(FND.segment_name) = LOWER(NVL(segmentname,FND.segment_name))

Line 65: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE ;

61: FROM gl_stat_account_uom
62: WHERE account_segment_value = acct_seg_val
63: AND chart_of_accounts_id = chart_of_accts_id ;
64:
65: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE ;
66:
67: BEGIN
68: IF NOT cur_get_segment_val%ISOPEN THEN
69: OPEN cur_get_segment_val(startdate,