APPS.LNS_DISTRIBUTIONS_PUB dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

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

2892: | PARAMETERS
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: |

Line 2923: , fnd_segment_attribute_values sav

2919: cursor c_segmentNumber(p_flex_code varchar2, p_application_id number, p_segment_attribute_type varchar2)
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

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

2964: | PARAMETERS
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: |

Line 2992: ,fnd_segment_attribute_values sav

2988:
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