APPS.GMS_PO_ADL_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 53: from po_req_distributions_all rd_old,

49: CURSOR c_req_rec is
50: select distinct rd_new.distribution_id new_distribution_id,
51: rd_old.distribution_id old_distribution_id,
52: rd_old.award_id award_set_id
53: from po_req_distributions_all rd_old,
54: po_req_distributions_all rd_new,
55: po_requisition_lines_all porl_old,
56: po_requisition_lines_all porl_new,
57: po_distributions pod,

Line 54: po_req_distributions_all rd_new,

50: select distinct rd_new.distribution_id new_distribution_id,
51: rd_old.distribution_id old_distribution_id,
52: rd_old.award_id award_set_id
53: from po_req_distributions_all rd_old,
54: po_req_distributions_all rd_new,
55: po_requisition_lines_all porl_old,
56: po_requisition_lines_all porl_new,
57: po_distributions pod,
58: po_headers_all blanket

Line 73: from po_req_distributions_all rd_old,

69: CURSOR c_req_rec is
70: select distinct rd_new.distribution_id new_distribution_id,
71: rd_old.distribution_id old_distribution_id,
72: rd_old.award_id award_set_id
73: from po_req_distributions_all rd_old,
74: po_req_distributions_all rd_new,
75: po_requisition_lines_all porl_new
76: where porl_new.requisition_line_id = nvl(p_req_line_id, -1 )
77: and rd_new.requisition_line_id = porl_new.requisition_line_id

Line 74: po_req_distributions_all rd_new,

70: select distinct rd_new.distribution_id new_distribution_id,
71: rd_old.distribution_id old_distribution_id,
72: rd_old.award_id award_set_id
73: from po_req_distributions_all rd_old,
74: po_req_distributions_all rd_new,
75: po_requisition_lines_all porl_new
76: where porl_new.requisition_line_id = nvl(p_req_line_id, -1 )
77: and rd_new.requisition_line_id = porl_new.requisition_line_id
78: and rd_new.award_id is null