APPS.FV_YE_CLOSE dependencies on PO_REQUISITION_LINES_ALL

Line 2898: FROM Po_Requisition_Lines_All

2894: AND gl_closed_date IS NULL;
2895:
2896: CURSOR get_header_cur IS
2897: SELECT DISTINCT requisition_header_id
2898: FROM Po_Requisition_Lines_All
2899: WHERE requisition_line_id = vt_lines(vl_index);
2900:
2901: CURSOR get_hcount_cur IS
2902: SELECT COUNT(*)

Line 2903: FROM Po_Requisition_Lines_All

2899: WHERE requisition_line_id = vt_lines(vl_index);
2900:
2901: CURSOR get_hcount_cur IS
2902: SELECT COUNT(*)
2903: FROM Po_Requisition_Lines_All
2904: WHERE requisition_header_id = vt_headers(vl_index)
2905: AND (closed_code <> 'FINALLY CLOSED' OR closed_code IS NULL);
2906: --AND NVL(closed_code, 'XXX') <> 'FINALLY CLOSED';
2907:

Line 2943: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph

2939: -- Build the select statement to get the distribution details
2940: vl_dist_select := 'SELECT po.distribution_id,
2941: po.requisition_line_id, ph.segment1
2942: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2943: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2944: WHERE po.gl_closed_date IS NULL
2945: AND gcc.code_combination_id = po.code_combination_id
2946: AND gcc.chart_of_accounts_id = :coa
2947: AND po.set_of_books_id = :sob

Line 3033: -- Update the Po_Requisition_Lines_All table

3029: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' VL_LINES_COUNT IS '||TO_CHAR(VL_LINES_COUNT));
3030: END IF;
3031:
3032: IF (vl_lines_count = 0) THEN -- vl_lines_count
3033: -- Update the Po_Requisition_Lines_All table
3034: UPDATE Po_Requisition_Lines_All
3035: SET closed_code = 'FINALLY CLOSED'
3036: WHERE requisition_line_id = vt_lines(vl_index);
3037:

Line 3034: UPDATE Po_Requisition_Lines_All

3030: END IF;
3031:
3032: IF (vl_lines_count = 0) THEN -- vl_lines_count
3033: -- Update the Po_Requisition_Lines_All table
3034: UPDATE Po_Requisition_Lines_All
3035: SET closed_code = 'FINALLY CLOSED'
3036: WHERE requisition_line_id = vt_lines(vl_index);
3037:
3038: vl_prt_line_id := vt_lines(vl_index);