APPS.FV_YE_CLOSE dependencies on PO_REQUISITION_LINES_ALL

Line 2848: FROM Po_Requisition_Lines_All

2844: AND gl_closed_date IS NULL;
2845:
2846: CURSOR get_header_cur IS
2847: SELECT DISTINCT requisition_header_id
2848: FROM Po_Requisition_Lines_All
2849: WHERE requisition_line_id = vt_lines(vl_index);
2850:
2851: CURSOR get_hcount_cur IS
2852: SELECT COUNT(*)

Line 2853: FROM Po_Requisition_Lines_All

2849: WHERE requisition_line_id = vt_lines(vl_index);
2850:
2851: CURSOR get_hcount_cur IS
2852: SELECT COUNT(*)
2853: FROM Po_Requisition_Lines_All
2854: WHERE requisition_header_id = vt_headers(vl_index)
2855: AND closed_code <> 'FINALLY CLOSED';
2856:
2857: l_module_name VARCHAR2(200) ;

Line 2890: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph

2886: -- Build the select statement to get the distribution details
2887: vl_dist_select := 'SELECT po.distribution_id,
2888: po.requisition_line_id, ph.segment1
2889: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2890: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2891: WHERE po.gl_closed_date IS NULL
2892: AND gcc.code_combination_id = po.code_combination_id
2893: AND gcc.chart_of_accounts_id = :coa
2894: AND po.set_of_books_id = :sob

Line 2980: -- Update the Po_Requisition_Lines_All table

2976: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' VL_LINES_COUNT IS '||TO_CHAR(VL_LINES_COUNT));
2977: END IF;
2978:
2979: IF (vl_lines_count = 0) THEN -- vl_lines_count
2980: -- Update the Po_Requisition_Lines_All table
2981: UPDATE Po_Requisition_Lines_All
2982: SET closed_code = 'FINALLY CLOSED'
2983: WHERE requisition_line_id = vt_lines(vl_index);
2984:

Line 2981: UPDATE Po_Requisition_Lines_All

2977: END IF;
2978:
2979: IF (vl_lines_count = 0) THEN -- vl_lines_count
2980: -- Update the Po_Requisition_Lines_All table
2981: UPDATE Po_Requisition_Lines_All
2982: SET closed_code = 'FINALLY CLOSED'
2983: WHERE requisition_line_id = vt_lines(vl_index);
2984:
2985: vl_prt_line_id := vt_lines(vl_index);