DBA Data[Home] [Help]

APPS.JA_CN_VOUCHER_NUM_PKG dependencies on GL_CODE_COMBINATIONS

Line 77: gl_code_combinations_kfv gcck,

73: gjh.POSTING_ACCT_SEQ_VALUE,
74: gjl.je_line_num
75: FROM gl_je_headers gjh,
76: gl_je_lines gjl,
77: gl_code_combinations_kfv gcck,
78: gl_ledgers glg
79: WHERE gjh.je_header_id = gjl.je_header_id
80: AND gcck.code_combination_id = gjl.code_combination_id
81: AND glg.ledger_id = gjh.ledger_id

Line 113: gl_code_combinations_kfv gcck,

109: gjh.POSTING_ACCT_SEQ_VALUE,
110: gjl.je_line_num
111: FROM gl_je_headers gjh,
112: gl_je_lines gjl,
113: gl_code_combinations_kfv gcck,
114: gl_ledgers glg
115: WHERE gjh.je_header_id = gjl.je_header_id
116: AND gcck.code_combination_id = gjl.code_combination_id
117: AND glg.ledger_id = gjh.ledger_id

Line 508: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

504: (P_CC_ID IN NUMBER
505: )
506: RETURN VARCHAR2
507: IS
508: L_BALANCING_SEGMENT GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
509: BEGIN
510: SELECT
511: DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
512: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 523: FROM GL_CODE_COMBINATIONS GCC,

519: 'SEGMENT22',GCC.SEGMENT22, 'SEGMENT23',GCC.SEGMENT23, 'SEGMENT24',GCC.SEGMENT24,
520: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
521: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
522: INTO L_BALANCING_SEGMENT
523: FROM GL_CODE_COMBINATIONS GCC,
524: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
525: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
526: AND FSAV.ATTRIBUTE_VALUE = 'Y'
527: AND FSAV.APPLICATION_ID = 101