APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on DUAL

Line 16: FROM dual

12: --
13: /* Commented the cursor IsVenInvPending for the bug# 2389458
14: CURSOR IsVenInvPending IS
15: SELECT 'VENDOR INVOICE PENDING'
16: FROM dual
17: WHERE EXISTS ( SELECT aid.invoice_id
18: FROM ap_invoice_distributions_all aid
19: WHERE aid.project_id = p_project_id
20: AND (p_active_flag = 'C' or

Line 33: FROM dual

29: /* Bug#2407499: Reverted the fix of the bug#2429757 as the cancelled invoices are
30: not handled by the pa_commitment_txns_v of the cursor IsCommitmentExist */
31: CURSOR IsVenInvPending IS
32: SELECT 'VENDOR INVOICE PENDING'
33: FROM dual
34: WHERE EXISTS ( SELECT aid.invoice_id
35: FROM ap_invoice_distributions_all aid,
36: ap_invoices_all ai
37: WHERE aid.project_id = p_project_id

Line 53: FROM dual

49: -- Asset Lines that are not yet transfered to FA
50: --
51: CURSOR IsAstLinNotXferred IS
52: SELECT 'ASSET LINE NOT TRANSFERRED'
53: FROM dual
54: WHERE EXISTS ( SELECT pal.project_asset_line_id
55: FROM pa_project_asset_lines_all pal
56: WHERE pal.project_id = p_project_id
57: AND pal.transfer_status_code <> 'T');

Line 64: FROM dual

60: -- CDLs that are not yet transfered to AP
61: --
62: CURSOR IsAdjNotXferToAP IS
63: SELECT 'ADJ NOT TRANSFERRED TO AP'
64: FROM dual
65: WHERE EXISTS (SELECT ei.expenditure_item_id
66: FROM pa_cost_distribution_lines_all cdl,
67: pa_expenditure_items_all ei
68: WHERE ei.expenditure_item_id = cdl.expenditure_item_id

Line 87: FROM dual

83: This is already handled as part of costing validation
84:
85: CURSOR IsEiNotCosted IS
86: SELECT 'EI NOT COSTED'
87: FROM dual
88: WHERE EXISTS ( SELECT ei.expenditure_item_id
89: FROM pa_expenditure_items_all ei,
90: pa_tasks pt
91: WHERE ei.system_linkage_function in ( 'VI', 'ER' )

Line 102: FROM dual

98: -- Expenditure items that are not yet Capitalized
99: --
100: CURSOR IsEiNotCapitalized IS
101: SELECT 'EXP ITEM NOT CAPITALIZED'
102: FROM dual
103: WHERE EXISTS ( SELECT pcdl.expenditure_item_id
104: FROM pa_cost_distribution_lines_all pcdl,
105: pa_expenditure_items_all pei,
106: pa_tasks pt,

Line 163: FROM dual

159: -- Expenditure items that are not yet Capitalized
160: --
161: CURSOR IsCommitmentExist IS
162: SELECT 'COMMITMENT EXISTS'
163: FROM dual
164: WHERE EXISTS ( SELECT pctv.project_id
165: FROM pa_commitment_txns_v pctv
166: WHERE pctv.project_id = p_project_id
167: AND pctv.expenditure_item_date is not null