APPS.JA_CN_UTILITY dependencies on GL_CODE_COMBINATIONS

Line 2912: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

2908: (P_CC_ID IN NUMBER
2909: )
2910: RETURN VARCHAR2
2911: IS
2912: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
2913: BEGIN
2914: SELECT
2915: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
2916: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 2927: FROM GL_CODE_COMBINATIONS GCC,

2923: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
2924: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
2925: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
2926: INTO L_BALANCING_SEGMENT
2927: FROM GL_CODE_COMBINATIONS GCC,
2928: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
2929: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
2930: AND FSAV.ATTRIBUTE_VALUE = 'Y'
2931: AND FSAV.APPLICATION_ID = 101

Line 2959: L_ACCOUNTING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

2955: -- CHANGE HISTORY:
2956: -- 22-Oct-2012 Jar Wang created
2957: --===========================================================================
2958: FUNCTION Get_Accounting_Segment(P_CC_ID IN NUMBER) RETURN VARCHAR2 IS
2959: L_ACCOUNTING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
2960: BEGIN
2961: SELECT DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
2962: 'SEGMENT1',
2963: GCC.SEGMENT1,

Line 3023: FROM GL_CODE_COMBINATIONS GCC, FND_SEGMENT_ATTRIBUTE_VALUES FSAV

3019: GCC.SEGMENT29,
3020: 'SEGMENT30',
3021: GCC.SEGMENT30)
3022: INTO L_ACCOUNTING_SEGMENT
3023: FROM GL_CODE_COMBINATIONS GCC, FND_SEGMENT_ATTRIBUTE_VALUES FSAV
3024: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
3025: AND FSAV.ATTRIBUTE_VALUE = 'Y'
3026: AND FSAV.APPLICATION_ID = 101
3027: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'