APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_COMMITMENT_TXNS_V

Line 30: not handled by the pa_commitment_txns_v of the cursor IsCommitmentExist */

26:
27: /* Bug#2429757 Commented out this cursor as this is generating a similar validation
28: error message like the cursor IsCommitmentExist */
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

Line 165: FROM pa_commitment_txns_v pctv

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
168: AND (p_active_flag = 'C' or
169: trunc(pctv.expenditure_item_date) <= trunc(p_purge_to_date))

Line 173: FROM pa_commitment_txns_v pctv1

169: trunc(pctv.expenditure_item_date) <= trunc(p_purge_to_date))
170: AND pctv.line_type not in ('P','I') /* Bug 2503781.*/
171: UNION /* Below lines added for bug 2503781 */
172: SELECT pctv1.project_id
173: FROM pa_commitment_txns_v pctv1
174: WHERE pctv1.project_id = p_project_id
175: AND pctv1.expenditure_item_date is not null
176: AND (p_active_flag = 'C' or
177: trunc(pctv1.expenditure_item_date) <= trunc(p_purge_to_date))

Line 214: not handled by the pa_commitment_txns_v of the cursor IsCommitmentExist */

210: /* Bug#2429757 Commented out this cursor as this is generating a similar validation
211: error message like the cursor IsCommitmentExist */
212:
213: /* Bug#2407499: Reverted the fix of the bug#2429757 as the cancelled invoices are
214: not handled by the pa_commitment_txns_v of the cursor IsCommitmentExist */
215:
216:
217: -- Check if there are any pending invoices in AP for this project which are not transferred
218: -- to PA