DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on FND_ID_FLEX_SEGMENTS

Line 2290: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,

2286: | PARAMETERS
2287: | p_segment_attribute_type = 'GL_BALANCING' 'GL_ACCOUNT' etc
2288: | Return value: value_set_id
2289: |
2290: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2291: | fnd_segment_attribute_types sat
2292: | lns_system_options lso
2293: | gl_sets_of_books gl
2294: |

Line 2316: FROM fnd_id_flex_segments s

2312:
2313: cursor c_segmentNumber(p_flex_code varchar2, p_application_id number, p_segment_attribute_type varchar2)
2314: is
2315: SELECT s.segment_num
2316: FROM fnd_id_flex_segments s
2317: , fnd_segment_attribute_values sav
2318: , fnd_segment_attribute_types sat
2319: , lns_system_options lso
2320: , gl_ledgers gl

Line 2362: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,

2358: | PARAMETERS
2359: | p_segment_attribute_type = 'GL_BALANCING' 'GL_ACCOUNT' etc
2360: | Return value: value_set_id
2361: |
2362: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2363: | fnd_segment_attribute_types sat
2364: | lns_system_options lso
2365: | gl_sets_of_books gl
2366: |

Line 2385: FROM fnd_id_flex_segments s

2381: l_value_set_id number;
2382:
2383: cursor c_valueSetID(p_segment_attribute_type varchar2) is
2384: SELECT s.flex_value_set_id
2385: FROM fnd_id_flex_segments s
2386: ,fnd_segment_attribute_values sav
2387: ,fnd_segment_attribute_types sat
2388: ,lns_system_options lso
2389: ,gl_ledgers gl