APPS.PA_BILLING_CYCLES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

      Select NVL(Start_date, Creation_date), billing_cycle_id,
              NVL(billing_offset,0)
      INTO proj_start_date, bill_cycle_id, bill_offset
      FROM PA_Projects_All
      WHERE project_id = Proj_ID;

Line: 132

    Select Billing_Cycle_Type, Billing_Value1,
            Billing_Value2, Billing_Value3,
            Billing_Value4, Billing_Value5
    From    PA_Billing_Cycles
    Where   Billing_Cycle_ID = X_Billing_Cycle_ID;

Line: 285

    select to_char(to_date('01-01-1950','DD-MM-YYYY') + BillValue(1)-1,'Day')
           Into  Bill_Day
           From Dual;

Line: 307

    select to_char(to_date('01-01-1950','DD-MM-YYYY') +BillValue(1)-1,'Day')
           Into  Bill_Day
           From Dual;

Line: 323

	Select Completion_date
	Into Bill_Date
	From PA_Projects_All
	Where Project_ID = X_Project_ID;

Line: 345

    select to_char(to_date('01-01-1950','DD-MM-YYYY') +BillValue(1)-1,'Day')
           Into  Bill_Day
           From Dual;

Line: 395

SELECT  MAX(NVL(Bill_through_date, Creation_date))
INTO    Last_Bill_thru_date
FROM    PA_Draft_Invoices_All
WHERE   Project_id = X_project_id
AND     nvl(retention_invoice_flag, 'N') = 'N'
AND     Draft_Invoice_Num_Credited IS NULL
AND     Released_By_Person_ID IS NOT NULL
AND     NVL(Canceled_Flag,'N') = 'N';

Line: 433

SELECT  MAX(DI.Draft_Invoice_Num)
INTO    Invoice_Num
FROM    PA_Draft_Invoices DI
WHERE   DI.Project_ID = X_Project_id
AND     DI.Draft_Invoice_Num_Credited IS NULL
AND     DI.Released_By_Person_ID IS NOT NULL
AND     NVL(DI.Canceled_Flag,'N') = 'N'
AND     NVL(DI.Bill_through_date, DI.Creation_date) = (
                SELECT  MAX(NVL(PDI.Bill_through_date, PDI.Creation_date))
                FROM    PA_Draft_Invoices PDI
                WHERE   PDI.Project_ID = DI.Project_ID
                AND     PDI.Draft_Invoice_Num_Credited IS NULL
                AND     PDI.Released_By_Person_ID IS NOT NULL
		AND     NVL(PDI.Canceled_Flag,'N') = 'N'
                        );