APPS.PO_CALCULATEREQTOTAL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 24: l_matching_basis po_requisition_lines_all.matching_basis%type;

20: p_line_id IN NUMBER,
21: p_distribution_id IN NUMBER)
22: RETURN NUMBER
23: IS
24: l_matching_basis po_requisition_lines_all.matching_basis%type;
25: l_action_type po_change_requests.action_type%type;
26: l_dist_total NUMBER := 0;
27: l_change_request_group_id po_change_requests.change_request_group_id%type;
28: BEGIN

Line 37: FROM po_requisition_lines_all prl,

33: nvl(prd.nonrecoverable_tax,0),
34: pcr.change_request_group_id
35: INTO l_matching_basis, l_action_type, l_dist_total,
36: l_change_request_group_id
37: FROM po_requisition_lines_all prl,
38: po_req_distributions_all prd,
39: po_change_requests pcr
40: WHERE prl.requisition_line_id = p_line_id
41: AND prl.requisition_line_id = prd.requisition_line_id

Line 115: po_requisition_lines_all prl,

111: prd.nonrecoverable_tax
112: INTO l_old_dist_total, l_new_dist_total, l_nonrec_tax
113: FROM po_change_requests pcr,
114: po_change_requests pcr1,
115: po_requisition_lines_all prl,
116: po_req_distributions_all prd
117: WHERE prd.distribution_id = p_distribution_id
118: AND pcr1.document_distribution_id(+) = prd.distribution_id
119: AND pcr1.document_line_id(+) = prd.requisition_line_id