APPS.RCV_TRANSACTION_SV dependencies on PJM_SEIBAN_NUMBERS
Line 109: IF x_project_id is not null AND x_project_number is null THEN --if x_project_number is still null then it could be in PJM_SEIBAN_NUMBERS
105: END;
106: END IF;
107:
108: x_progress := 23; 109: IF x_project_id is not null AND x_project_number is null THEN --if x_project_number is still null then it could be in PJM_SEIBAN_NUMBERS 110: BEGIN
111: x_progress := 25;
112: select PSN.PROJECT_NUMBER ,
113: NULL
Line 116: from PJM_SEIBAN_NUMBERS PSN
112: select PSN.PROJECT_NUMBER ,
113: NULL
114: into x_project_number,
115: x_task_number 116: from PJM_SEIBAN_NUMBERS PSN 117: where PSN.project_id = x_project_id;
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN
120: x_project_number := NULL;