APPS.LNS_DISTRIBUTIONS_PUB dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

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 2317: , fnd_segment_attribute_values sav

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
2321: WHERE s.application_id = p_application_id

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 2386: ,fnd_segment_attribute_values sav

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
2390: WHERE s.application_id = 101