APPS.PA_RETN_BILLING_PKG dependencies on DUAL

Line 91: FROM DUAL

87:
88: BEGIN
89: SELECT 'Y'
90: INTO ExistsFlag
91: FROM DUAL
92: WHERE EXISTS(SELECT NULL
93: FROM pa_draft_invoices_all
94: WHERE project_id = p_project_id
95: AND agreement_id = p_agreement_id

Line 424: FROM DUAL;

420: -- Generate a set id, happens only user run the retention invoice generation
421:
422: SELECT PA_DRAFT_INVOICES_S.NEXTVAL
423: INTO TmpInvoiceSetId
424: FROM DUAL;
425:
426: ELSE
427: TmpInvoiceSetId := pa_billing.Globvars.InvoiceSetId;
428: END IF;

Line 1179: FROM DUAL;

1175: -- Select the sequence values
1176:
1177: SELECT pa_retn_invoice_details_s.NEXTVAL
1178: INTO l_detail_id
1179: FROM DUAL;
1180:
1181: IF g1_debug_mode = 'Y' THEN
1182: pa_retention_util.write_log('Create_Retn_Invoice_Details: ' || 'Insert pa_retn_invoice_details');
1183: END IF;