DBA Data[Home] [Help]

APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 114: FND_ID_FLEX_SEGMENTS fs,

110:
111: CURSOR csr_chk_qual_segments IS
112: SELECT 'M'
113: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa2,
114: FND_ID_FLEX_SEGMENTS fs,
115: FND_SEGMENT_ATTRIBUTE_VALUES sa1
116: WHERE sa1.id_flex_num = p_cost_id_flex_num
117: and sa1.id_flex_code = 'COST'
118: and sa1.attribute_value = 'Y'

Line 199: FROM FND_ID_FLEX_SEGMENTS fs,

195: --
196:
197: SELECT count(*)
198: INTO l_num_reqs_in_this_level
199: FROM FND_ID_FLEX_SEGMENTS fs,
200: FND_SEGMENT_ATTRIBUTE_VALUES sa1
201: WHERE sa1.id_flex_num = p_cost_id_flex_num
202: and sa1.id_flex_code = 'COST'
203: and sa1.application_id = fs.application_id

Line 444: from fnd_id_flex_segments

440: is
441: --
442: cursor csr_segment_exists is
443: select 'Y'
444: from fnd_id_flex_segments
445: where application_id = 801
446: and id_flex_num = p_cost_id_flex_num
447: and id_flex_code = 'COST'
448: and application_column_name = p_segment_name