APPS.PA_FUND_REVAL_PVT dependencies on DUAL

Line 923: FROM DUAL

919:
920: END IF;
921:
922: SELECT 'T' INTO x_exist_flag
923: FROM DUAL
924: WHERE EXISTS ( SELECT NULL
925: FROM pa_draft_revenues r
926: WHERE r.project_id = p_project_id
927: AND r.released_date IS NULL);

Line 950: FROM DUAL

946:
947: END IF;
948:
949: SELECT 'T' INTO x_exist_flag
950: FROM DUAL
951: WHERE EXISTS ( SELECT NULL
952: FROM pa_draft_invoices i
953: WHERE i.project_id = p_project_id
954: and i.released_by_person_id IS NULL);

Line 1021: FROM DUAL

1017:
1018: END IF;
1019:
1020: SELECT 'T' INTO l_ExistFlag
1021: FROM DUAL
1022: WHERE EXISTS (SELECT NULL
1023: FROM pa_project_fundings
1024: WHERE project_id = p_project_id
1025: AND funding_category = 'REVALUATION'

Line 6346: FROM DUAL

6342:
6343: /* Check if the invoice has any retention lines. Only if it exists subsequent code will get processed */
6344:
6345: SELECT 'T' INTO l_RetnExistFlag
6346: FROM DUAL
6347: WHERE EXISTS (SELECT NULL
6348: FROM pa_draft_invoice_items dii
6349: WHERE dii.project_id = p_project_id
6350: AND dii.draft_invoice_num = p_draft_inv_num

Line 9194: FROM DUAL

9190: l_LogMsg VARCHAR2(250);
9191:
9192: CURSOR check_all_non_zero_amt(l_project_funding_id NUMBER) IS
9193: SELECT 'Y' non_zero_amt
9194: FROM DUAL
9195: WHERE EXISTS ( SELECT NULL
9196: FROM pa_project_fundings
9197: WHERE project_funding_id = l_project_funding_id
9198: AND ( projfunc_allocated_amount <> 0

Line 9566: FROM DUAL

9562: l_NonZeroExists VARCHAR2(1);
9563:
9564: CURSOR check_all_non_zero_amt(l_EventId NUMBER) IS
9565: SELECT 'Y' non_zero_amt
9566: FROM DUAL
9567: WHERE EXISTS ( SELECT NULL
9568: FROM pa_events
9569: WHERE event_id = l_EventId
9570: AND bill_trans_rev_amount <> 0