DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 338: Fnd_Segment_Attribute_Values Fsav,

334: --get application column name of company segment
335: SELECT Fsav.Application_Column_Name
336: INTO l_Company_Column_Name
337: FROM Fnd_Id_Flex_Segments Fifs,
338: Fnd_Segment_Attribute_Values Fsav,
339: Gl_Ledgers Led
340: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
341: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
342: AND Fsav.Segment_Attribute_Type = 'GL_BALANCING'

Line 470: Fnd_Segment_Attribute_Values Fsav,

466:
467: CURSOR c_Cost_Center IS
468: SELECT Fsav.Application_Column_Name
469: FROM Fnd_Id_Flex_Segments Fifs,
470: Fnd_Segment_Attribute_Values Fsav,
471: Gl_Ledgers Led
472: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
473: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
474: AND Fsav.Segment_Attribute_Type = 'FA_COST_CTR'

Line 487: Fnd_Segment_Attribute_Values Fsav,

483: --jogen
484: CURSOR c_Segements IS
485: SELECT Fsav.Application_Column_Name
486: FROM Fnd_Id_Flex_Segments Fifs,
487: Fnd_Segment_Attribute_Values Fsav,
488: Gl_Ledgers Led
489: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
490: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
491: AND Fsav.Segment_Attribute_Type = 'GL_GLOBAL'

Line 520: Fnd_Segment_Attribute_Values Fsav,

516: --get application column name of account segment
517: SELECT Fsav.Application_Column_Name
518: INTO l_Account_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 = 'GL_ACCOUNT'

Line 571: Fnd_Segment_Attribute_Values Fsav,

567: BEGIN
568: SELECT Fsav.Application_Column_Name
569: INTO l_Second_Track_Col_Name
570: FROM Fnd_Id_Flex_Segments Fifs,
571: Fnd_Segment_Attribute_Values Fsav,
572: Gl_Ledgers Led
573: WHERE Fifs.Id_Flex_Num = Fsav.Id_Flex_Num
574: AND Fifs.Application_Column_Name = Fsav.Application_Column_Name
575: AND Fsav.Segment_Attribute_Type = 'GL_SECONDARY_TRACKING'