APPS.LNS_DISTRIBUTIONS_PUB dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 2291: | fnd_segment_attribute_types sat

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: |
2295: | Target Tables: NA

Line 2318: , fnd_segment_attribute_types sat

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
2322: and lso.set_of_books_id = gl.ledger_id

Line 2363: | fnd_segment_attribute_types sat

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: |
2367: | Target Tables: NA

Line 2387: ,fnd_segment_attribute_types sat

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
2391: and lso.set_of_books_id = gl.ledger_id