APPS.IGI_BUD dependencies on GL_JE_LINES

Line 659: FROM GL_JE_LINES

655: CURSOR lines IS
656: SELECT JE_LINE_NUM
657: , CODE_COMBINATION_ID
658: , REFERENCE_3
659: FROM GL_JE_LINES
660: WHERE JE_HEADER_ID = p_je_header_id;
661:
662: l_line_reference_3 gl_je_lines.reference_3%type;
663: BEGIN

Line 662: l_line_reference_3 gl_je_lines.reference_3%type;

658: , REFERENCE_3
659: FROM GL_JE_LINES
660: WHERE JE_HEADER_ID = p_je_header_id;
661:
662: l_line_reference_3 gl_je_lines.reference_3%type;
663: BEGIN
664: FOR line IN lines LOOP
665: BEGIN
666: INSERT INTO IGI_BUD_NY_BALANCES

Line 680: FROM GL_JE_LINES gjl

676: , p_budget_version_id
677: , p_period_name
678: , p_currency_code
679: , NVL(gjl.REFERENCE_8,0)
680: FROM GL_JE_LINES gjl
681: WHERE gjl.JE_HEADER_ID = p_je_header_id
682: AND gjl.JE_LINE_NUM = line.JE_LINE_NUM
683: --
684: -- 01-NOV-00 EGARRETT Start(1)

Line 699: FROM GL_JE_LINES

695: EXCEPTION
696: WHEN dup_val_on_index THEN
697: SELECT CODE_COMBINATION_ID
698: INTO p_code_combination_id
699: FROM GL_JE_LINES
700: WHERE JE_HEADER_ID = p_je_header_id
701: AND JE_LINE_NUM = line.JE_LINE_NUM;
702:
703: UPDATE IGI_BUD_NY_BALANCES nyb

Line 707: FROM GL_JE_LINES gjl

703: UPDATE IGI_BUD_NY_BALANCES nyb
704: SET NEXT_YEAR_BUDGET =
705: (SELECT nyb.NEXT_YEAR_BUDGET +
706: NVL(gjl.REFERENCE_8,0)
707: FROM GL_JE_LINES gjl
708: WHERE gjl.JE_HEADER_ID = p_je_header_id
709: AND gjl.JE_LINE_NUM = line.JE_LINE_NUM
710: -- 01-NOV-00 EGARRETT Start(2)
711: AND is_number(NVL(gjl.reference_8,0)) = 1)