333:
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
465: where Led.Ledger_Id = l_Ledger_Id;
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
482:
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
515:
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
566: ---jogen
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