APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 366: po_req_distributions_all prd,

362: nvl(pcr2.new_quantity,prd.req_line_quantity)*prd.nonrecoverable_tax
363: /(prl.unit_price*prd.req_line_quantity))), FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
364: into l_new_tax_amount
365: from po_requisition_lines_all prl,
366: po_req_distributions_all prd,
367: po_change_requests pcr1,
368: po_change_requests pcr2
369: where prl.requisition_line_id=pcr1.document_line_id(+)
370: and pcr1.change_request_group_id(+)=l_change_request_group_id

Line 385: po_req_distributions_all prd,

381: nvl(pcr2.new_quantity,prd.req_line_quantity))),
382: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
383: into l_new_req_amount
384: from po_requisition_lines_all prl,
385: po_req_distributions_all prd,
386: po_change_requests pcr1,
387: po_change_requests pcr2
388: where prl.requisition_line_id=pcr1.document_line_id(+)
389: and pcr1.change_request_group_id(+)=l_change_request_group_id

Line 702: FROM PO_REQ_DISTRIBUTIONS_ALL

698:
699:
700: CURSOR ccId_csr(req_line_id NUMBER) IS
701: SELECT CODE_COMBINATION_ID
702: FROM PO_REQ_DISTRIBUTIONS_ALL
703: WHERE REQUISITION_LINE_ID = req_line_id;
704:
705:
706: BEGIN

Line 1213: FROM PO_REQ_DISTRIBUTIONS_ALL

1209:
1210:
1211: CURSOR ccId_csr(req_line_id NUMBER) IS
1212: SELECT CODE_COMBINATION_ID
1213: FROM PO_REQ_DISTRIBUTIONS_ALL
1214: WHERE REQUISITION_LINE_ID = req_line_id;
1215:
1216: cursor l_get_wf_keys_csr is
1217: select wf_item_type, wf_item_key

Line 2034: po_req_distributions_all rd --

2030: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
2031: ||' '|| l_currency_code
2032: INTO l_new_tax_amount
2033: FROM po_requisition_lines rl,
2034: po_req_distributions_all rd --
2035: WHERE rl.requisition_header_id = l_document_id
2036: AND rd.requisition_line_id = rl.requisition_line_id
2037: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'
2038: and NVL(rl.cancel_flag, 'N')='N';