APPS.PO_CONTRACTS_S dependencies on PO_HEADERS

Line 18: X_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE; --Bug# 4685260

14: X_current_amount NUMBER := 0;
15: X_purchased_amount NUMBER := 0;
16: X_contract_id NUMBER := 0;
17: X_progress NUMBER := 10;
18: X_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE; --Bug# 4685260
19: X_rate PO_HEADERS_ALL.RATE%TYPE; --Bug# 4685260
20:
21: l_amount_limit_func NUMBER; -- bug3673292
22: x_diff_curr VARCHAR2(1); --Bug# 4685260

Line 19: X_rate PO_HEADERS_ALL.RATE%TYPE; --Bug# 4685260

15: X_purchased_amount NUMBER := 0;
16: X_contract_id NUMBER := 0;
17: X_progress NUMBER := 10;
18: X_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE; --Bug# 4685260
19: X_rate PO_HEADERS_ALL.RATE%TYPE; --Bug# 4685260
20:
21: l_amount_limit_func NUMBER; -- bug3673292
22: x_diff_curr VARCHAR2(1); --Bug# 4685260
23:

Line 33: po_headers contracts -- --

29: contracts.amount_limit ,
30: NVL(contracts.rate, 1), -- Bug# 4685260
31: contracts.currency_code --Bug# 4685260
32: FROM po_lines_gt pol, --
33: po_headers contracts -- --
34: WHERE contracts.po_header_id = pol.contract_id
35: AND NVL(contracts.global_agreement_flag, 'N') = 'N' --
36: AND pol.po_header_id = X_po_header_id
37: AND contracts.amount_limit IS NOT NULL; -- bug3673292

Line 104: po_headers poh2

100: where exists (
101: SELECT 'Exists'
102: FROM po_lines pol,
103: po_line_locations pll,
104: po_headers poh2
105: WHERE pol.contract_id = X_contract_id --
106: AND pol.po_line_id = pll.po_line_id
107: AND poh2.po_header_id = pol.po_header_id
108: AND (( poh2.authorization_status = 'APPROVED')

Line 116: po_headers_gt potoapp --

112: UNION ALL
113: SELECT 'Exists'
114: FROM po_lines_gt pol, --
115: po_line_locations_gt pll, --
116: po_headers_gt potoapp --
117: WHERE pol.contract_id = X_contract_id --
118: AND pol.po_line_id = pll.po_line_id
119: AND pol.po_header_id = potoapp.po_header_id
120: AND potoapp.po_header_id = X_po_header_id

Line 156: po_headers poh2

152: )
153: INTO X_purchased_amount
154: FROM po_lines pol,
155: po_line_locations pll,
156: po_headers poh2
157: WHERE pol.contract_id = X_contract_id --
158: AND pol.po_line_id = pll.po_line_id
159: AND poh2.po_header_id = pol.po_header_id
160: AND (( poh2.authorization_status = 'APPROVED')

Line 197: po_headers_gt potoapp --

193: )
194: INTO X_current_amount
195: FROM po_lines_gt pol, --
196: po_line_locations_gt pll, --
197: po_headers_gt potoapp --
198: WHERE pol.contract_id = X_contract_id --
199: AND pol.po_line_id = pll.po_line_id
200: AND pol.po_header_id = potoapp.po_header_id
201: AND potoapp.po_header_id = X_po_header_id;