APPS.PA_BILLING_CYCLES_PKG dependencies on PA_PROJECTS_ALL

Line 51: FROM PA_Projects_All

47: Begin
48: Select NVL(Start_date, Creation_date), billing_cycle_id,
49: NVL(billing_offset,0)
50: INTO proj_start_date, bill_cycle_id, bill_offset
51: FROM PA_Projects_All
52: WHERE project_id = Proj_ID;
53: Exception When NO_DATA_FOUND THEN
54: NULL;
55: End;

Line 325: From PA_Projects_All

321: ELSIF Bill_Rec.Billing_Cycle_Type = 'PROJECT COMPLETION' then
322: /** Get the completion date for the project **/
323: Select Completion_date
324: Into Bill_Date
325: From PA_Projects_All
326: Where Project_ID = X_Project_ID;
327:
328: IF (Bill_date IS NULL) AND (X_Bill_Thru_Date IS NOT NULL) then
329: /** Project not yet complete.