APPS.PO_CHORD_WF5 dependencies on PO_RELEASES_ARCHIVE_ALL

Line 74: PO_RELEASES_ARCHIVE_all PORA

70: BEGIN
71: SELECT DISTINCT 'Y'
72: INTO x_release_control.agent_id
73: FROM PO_RELEASES_all POR,
74: PO_RELEASES_ARCHIVE_all PORA
75: WHERE POR.po_release_id = x_po_release_id
76: AND POR.po_release_id = PORA.po_release_id
77: AND PORA.latest_external_flag (+) = 'Y'
78: AND (

Line 96: PO_RELEASES_ARCHIVE_all PORA

92: BEGIN
93: SELECT DISTINCT 'Y'
94: INTO x_release_control.acceptance_required_flag
95: FROM PO_RELEASES_all POR,
96: PO_RELEASES_ARCHIVE_all PORA
97: WHERE POR.po_release_id = x_po_release_id
98: AND POR.po_release_id = PORA.po_release_id
99: AND PORA.latest_external_flag (+) = 'Y'
100: AND (

Line 118: PO_RELEASES_ARCHIVE_all PORA

114: BEGIN
115: SELECT DISTINCT 'Y'
116: INTO x_release_control.acceptance_due_date
117: FROM PO_RELEASES_all POR,
118: PO_RELEASES_ARCHIVE_all PORA
119: WHERE POR.po_release_id = x_po_release_id
120: AND POR.po_release_id = PORA.po_release_id
121: AND PORA.latest_external_flag (+) = 'Y'
122: AND (

Line 140: PO_RELEASES_ARCHIVE_all PORA

136: BEGIN
137: SELECT DISTINCT 'Y'
138: INTO x_release_control.release_num
139: FROM PO_RELEASES_all POR,
140: PO_RELEASES_ARCHIVE_all PORA
141: WHERE POR.po_release_id = x_po_release_id
142: AND POR.po_release_id = PORA.po_release_id
143: AND PORA.latest_external_flag (+) = 'Y'
144: AND (

Line 162: PO_RELEASES_ARCHIVE_all PORA

158: BEGIN
159: SELECT DISTINCT 'Y'
160: INTO x_release_control.release_date
161: FROM PO_RELEASES_all POR,
162: PO_RELEASES_ARCHIVE_all PORA
163: WHERE POR.po_release_id = x_po_release_id
164: AND POR.po_release_id = PORA.po_release_id
165: AND PORA.latest_external_flag (+) = 'Y'
166: AND (