APPS.PO_AUTO_DIST_PROCESS_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 869: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;

865: l_return_status VARCHAR2(1);
866: l_msg_count NUMBER;
867: l_msg_data VARCHAR2(2000);
868: l_gl_date_option VARCHAR2(25);
869: l_sob_id PO_REQ_DISTRIBUTIONS_ALL.set_of_books_id%TYPE;
870: -- Acct. Generator Variables Start
871: l_dest_charge_success BOOLEAN := TRUE;
872: l_dest_variance_success BOOLEAN := TRUE;
873: l_charge_success BOOLEAN := TRUE;

Line 971: FROM po_req_distributions_all prd

967: calling PO_PERIODS_SV.get_period_name to make it consistent.
968: If the get_period_name does not return a period then we will call build_GL_Encumbered_Date in case of PO:validate GL period = 'Redefault'*/
969: SELECT prd.set_of_books_id
970: INTO l_sob_id
971: FROM po_req_distributions_all prd
972: WHERE prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)
973: AND ROWNUM = 1;
974:
975: d_progress := 50;

Line 1156: po_req_distributions_all prd ,

1152: prd.funded_value
1153: /*Bug 13598209 : PO_LINE_LOCATIONS_ALL has still not been populated
1154: Hence PO_LINE_LOCATIONS_DRAFT_ALL needs to be used*/
1155: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll ,
1156: po_req_distributions_all prd ,
1157: po_requisition_lines_all prl
1158: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1159: AND prd.requisition_line_id = p_lines.requisition_line_id_tbl(i)
1160: AND prl.requisition_line_id = prd.requisition_line_id