APPS.RCV_TRANSACTION_SV dependencies on PJM_SEIBAN_NUMBERS
Line 121: 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
117: End;
118: END IF;
119:
120: x_progress := 23; 121: 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 122: BEGIN
123: x_progress := 25;
124: select PSN.PROJECT_NUMBER ,
125: NULL
Line 128: from PJM_SEIBAN_NUMBERS PSN
124: select PSN.PROJECT_NUMBER ,
125: NULL
126: into x_project_number,
127: x_task_number 128: from PJM_SEIBAN_NUMBERS PSN 129: where PSN.project_id = x_project_id;
130: EXCEPTION
131: WHEN NO_DATA_FOUND THEN
132: x_project_number := NULL;