APPS.IGI_ITR dependencies on GL_JE_LINES

Line 567: from gl_je_lines

563: and je_source = 'Internal Trading';
564:
565: cursor c_line(c_header_id number)
566: is select reference_1,reference_2
567: from gl_je_lines
568: where je_header_id = c_header_id;
569:
570: begin
571: select budgetary_control_status, status,actual_flag into

Line 612: DELETE gl_je_lines where je_header_id IN

608: WHERE it_header_id = current_line.reference_1
609: AND it_line_num = current_line.reference_2;
610: end if;
611:
612: DELETE gl_je_lines where je_header_id IN
613: ( SELECT je_header_id
614: FROM gl_je_headers
615: WHERE je_batch_id = p_batch_id
616: );

Line 637: DELETE gl_je_lines where je_header_id IN

633: WHERE it_header_id = current_line.reference_1
634: AND it_line_num = current_line.reference_2;
635: end if;
636:
637: DELETE gl_je_lines where je_header_id IN
638: (SELECT je_header_id
639: FROM gl_je_headers
640: WHERE je_batch_id = p_batch_id);
641: delete gl_je_headers where je_batch_id = p_batch_id;

Line 661: /* DELETE gl_je_lines where je_header_id IN

657: WHERE it_header_id = current_line.reference_1
658: AND it_line_num = current_line.reference_2;
659: end if;
660:
661: /* DELETE gl_je_lines where je_header_id IN
662: ( SELECT je_header_id
663: FROM gl_je_headers
664: WHERE je_batch_id = p_batch_id
665: );

Line 683: DELETE gl_je_lines where je_header_id IN

679: WHERE it_header_id = current_line.reference_1
680: AND it_line_num = current_line.reference_2;
681: end if;
682:
683: DELETE gl_je_lines where je_header_id IN
684: ( SELECT je_header_id
685: FROM gl_je_headers
686: WHERE je_batch_id = p_batch_id
687: );