APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_LINES

Line 139: l_cash_flow_item_from_GL gl_je_lines.attribute1%TYPE;

135: l_com_seg varchar2(150); --company segment of a line's account
136: l_com_seg_check number; --flag of an account's company segment belongs to current LE or not
137: l_account_check number; --flag of an account in cash related table or not
138: l_line_chk varchar2(20); --result of a line's validation
139: l_cash_flow_item_from_GL gl_je_lines.attribute1%TYPE;
140:
141: --Cursor to get FFV.Flex_Value and segment FSAV.APPLICATION_COLUMN_NAME of gcc
142: CURSOR c_ffv IS
143: SELECT FFV.Flex_Value ffv_flex_value

Line 282: FROM gl_je_lines jel

278: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
279: 'ATTRIBUTE15',jel.attribute15)
280: ) cash_related_item
281: INTO l_cash_flow_item_from_GL
282: FROM gl_je_lines jel
283: , fun_trx_headers trxh
284: , fun_trx_lines trxl
285: , fun_dist_lines distl
286: ,ja_cn_dff_assignments dffa

Line 685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;

681: l_je_catg GL_JE_HEADERS.je_category%TYPE;
682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
684: l_je_desc GL_JE_HEADERS.description%TYPE;
685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
686: l_je_line_desc GL_JE_LINES.description%TYPE;
687: l_language VARCHAR(100):=userenv('LANG');
688: l_characterset varchar(245);
689:

Line 686: l_je_line_desc GL_JE_LINES.description%TYPE;

682: l_je_usr_catg gl_je_categories_tl.user_je_category_name%TYPE;
683: l_je_eff_date GL_JE_HEADERS.default_effective_date%TYPE;
684: l_je_desc GL_JE_HEADERS.description%TYPE;
685: l_je_line_num GL_JE_LINES.je_line_num%TYPE;
686: l_je_line_desc GL_JE_LINES.description%TYPE;
687: l_language VARCHAR(100):=userenv('LANG');
688: l_characterset varchar(245);
689:
690: --Cursor to get all periods between (P_START_PERIOD, P_END_PERIOD).

Line 783: FROM GL_JE_LINES jel

779: 'ATTRIBUTE9',jel.attribute9, 'ATTRIBUTE10',jel.attribute10, 'ATTRIBUTE11',jel.attribute11,
780: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
781: 'ATTRIBUTE15',jel.attribute15)
782: ) cash_related_item
783: FROM GL_JE_LINES jel
784: ,ja_cn_dff_assignments dffa
785: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
786: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
787: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id