DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 358: Fnd_Segment_Attribute_Values Fsav,

354: --get application column name of company segment
355: SELECT Fsav.Application_Column_Name
356: INTO l_Company_Column_Name
357: FROM Fnd_Id_Flex_Segments Fifs,
358: Fnd_Segment_Attribute_Values Fsav,
359: Gl_Ledgers Led
360: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
361: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
362: AND Fsav.Segment_Attribute_Type = 'GL_BALANCING'

Line 520: Fnd_Segment_Attribute_Values Fsav,

516:
517: CURSOR c_Cost_Center IS
518: SELECT Fsav.Application_Column_Name
519: FROM Fnd_Id_Flex_Segments Fifs,
520: Fnd_Segment_Attribute_Values Fsav,
521: Gl_Ledgers Led
522: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
523: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
524: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'

Line 537: Fnd_Segment_Attribute_Values Fsav,

533: --jogen
534: CURSOR c_Segements IS
535: SELECT Fsav.Application_Column_Name
536: FROM Fnd_Id_Flex_Segments Fifs,
537: Fnd_Segment_Attribute_Values Fsav,
538: Gl_Ledgers Led
539: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
540: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
541: AND Fsav.Segment_Attribute_Type = 'GL_GLOBAL'

Line 576: Fnd_Segment_Attribute_Values Fsav,

572: --get application column name of account segment
573: SELECT Fsav.Application_Column_Name
574: INTO l_Account_Column_Name
575: FROM Fnd_Id_Flex_Segments Fifs,
576: Fnd_Segment_Attribute_Values Fsav,
577: Gl_Ledgers Led
578: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
579: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
580: AND Fsav.Segment_Attribute_Type = 'GL_ACCOUNT'

Line 654: Fnd_Segment_Attribute_Values Fsav,

650: BEGIN
651: SELECT Fsav.Application_Column_Name
652: INTO l_Second_Track_Col_Name
653: FROM Fnd_Id_Flex_Segments Fifs,
654: Fnd_Segment_Attribute_Values Fsav,
655: Gl_Ledgers Led
656: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
657: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
658: AND Fsav.Segment_Attribute_Type = 'GL_SECONDARY_TRACKING'