APPS.LNS_DISTRIBUTIONS_PUB dependencies on FND_SEGMENT_ATTRIBUTE_TYPES

Line 2897: | fnd_segment_attribute_types sat

2893: | p_segment_attribute_type = 'GL_BALANCING' 'GL_ACCOUNT' etc
2894: | Return value: value_set_id
2895: |
2896: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2897: | fnd_segment_attribute_types sat
2898: | lns_system_options lso
2899: | gl_sets_of_books gl
2900: |
2901: | Target Tables: NA

Line 2924: , fnd_segment_attribute_types sat

2920: is
2921: SELECT s.segment_num
2922: FROM fnd_id_flex_segments s
2923: , fnd_segment_attribute_values sav
2924: , fnd_segment_attribute_types sat
2925: , lns_system_options lso
2926: , gl_ledgers gl
2927: WHERE s.application_id = p_application_id
2928: and lso.set_of_books_id = gl.ledger_id

Line 2969: | fnd_segment_attribute_types sat

2965: | p_segment_attribute_type = 'GL_BALANCING' 'GL_ACCOUNT' etc
2966: | Return value: value_set_id
2967: |
2968: | Source Tables: fnd_id_flex_segments s, fnd_segment_attribute_values sav,
2969: | fnd_segment_attribute_types sat
2970: | lns_system_options lso
2971: | gl_sets_of_books gl
2972: |
2973: | Target Tables: NA

Line 2993: ,fnd_segment_attribute_types sat

2989: cursor c_valueSetID(p_segment_attribute_type varchar2) is
2990: SELECT s.flex_value_set_id
2991: FROM fnd_id_flex_segments s
2992: ,fnd_segment_attribute_values sav
2993: ,fnd_segment_attribute_types sat
2994: ,lns_system_options lso
2995: ,gl_ledgers gl
2996: WHERE s.application_id = 101
2997: and lso.set_of_books_id = gl.ledger_id