DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 357: FROM Fnd_Id_Flex_Segments Fifs,

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

Line 519: FROM Fnd_Id_Flex_Segments Fifs,

515: where Led.Ledger_Id = l_Ledger_Id;
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

Line 536: FROM Fnd_Id_Flex_Segments Fifs,

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

Line 575: FROM Fnd_Id_Flex_Segments Fifs,

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

Line 653: FROM Fnd_Id_Flex_Segments Fifs,

649: ---jogen
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