APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 27: rem FND_SEGMENT_ATTRIBUTE_VALUES.

23: rem getting into various levels
24: rem of costing.
25: rem 115.5 25-MAY-2003 A.Logue Further qualify by id_flex_code
26: rem = 'COST' when joining to
27: rem FND_SEGMENT_ATTRIBUTE_VALUES.
28: rem And NOCOPY changes.
29: rem Bug 2961843.
30: rem 115.6 25-Sep-2003 swinton Enhancement 3121279. Added:
31: rem - cost_keyflex_segment_defined function

Line 113: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa2,

109: l_proc VARCHAR2(72) := g_package||'costing_kff_seg_behaviour';
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'

Line 115: FND_SEGMENT_ATTRIBUTE_VALUES sa1

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'
119: and sa1.segment_attribute_type <> 'BALANCING'

Line 147: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa

143: SELECT 'N'
144: FROM DUAL
145: WHERE NOT EXISTS
146: (SELECT 'Y'
147: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa
148: WHERE sa.id_flex_num = p_cost_id_flex_num
149: and sa.id_flex_code = 'COST'
150: and sa.application_id = 801
151: and sa.segment_attribute_type = p_level

Line 165: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa

161: FROM DUAL
162: WHERE p_level = 'ELEMENT'
163: and NOT EXISTS
164: (SELECT 'Y'
165: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa
166: WHERE sa.id_flex_num = p_cost_id_flex_num
167: and sa.id_flex_code = 'COST'
168: and sa.application_id = 801
169: and sa.segment_attribute_type = 'BALANCING'

Line 200: FND_SEGMENT_ATTRIBUTE_VALUES sa1

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
204: and sa1.attribute_value = 'Y'

Line 348: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa1

344: Hr_Utility.Set_Location(l_proc, 10);
345:
346: SELECT decode(attribute_value, 'Y', p_segment_value, null)
347: INTO p_segment_value
348: FROM FND_SEGMENT_ATTRIBUTE_VALUES sa1
349: WHERE sa1.id_flex_num = p_cost_id_flex_num
350: AND sa1.id_flex_code = 'COST'
351: AND sa1.application_id = 801
352: AND sa1.application_column_name = p_segment